Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Memory usage with Memory Tables?
Fri, May 18 2007 6:35 PMPermanent Link

"Ian Branch"
Hi Guys,

   Is there any general guideline to the amount of actual Memory wil be
used/consumed by reading data into Memory tables?

   The reason for the question is that as I understand it is that in a particular
application I have I can save a lot of server disk access and Network Traffic
if I read all of my lookup tables into local memory tables.

   The question then is how much memory may be consumed which may then lead to a
minimum memory spec for the client machines.

Regards & TIA,

Ian

--
Sat, May 19 2007 3:56 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


As a guess the same as for the space a disk table takes on disk.

Roy Lambert
Tue, May 22 2007 8:25 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ian,

<< The question then is how much memory may be consumed which may then lead
to a minimum memory spec for the client machines. >>

It's the same as disk-based tables, just rounded off to a 4k boundary.  So,
take the total table size, mod it by 4k, and then multiply that result by 4k
to get the total memory footprint.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, May 23 2007 7:08 AMPermanent Link

"Ian Branch"
Thanks Guys,

Regards,

Ian



--
Image