Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread [FILTER PERFORMANCE] how dbisam manages memory allocation?
Tue, Mar 21 2006 6:04 AMPermanent Link

"Antony Miller"
Hi,
   I'm using D7 with dbisam 4.19.
I have a table ( local tdbIsamTable , not memory) with filter properties
populate, filtered set true and code in onfilter event.
In my application I open the table and then I analize it by a classic do
while loop.

I have understood that if I close all my applications the loop requires from
3 to 10 seconds
but
if I leave any applications ( outlook..word...MSN7...Delphi IDE... ) opened
it requires 1 minute or more ( HardDisk work much ) ...

I think it depends how dbisam manages the memory allocation for filtered
table and so i have tried fastmm without great results.
I'm using a fast notebook with 1Gb RAM and some Gb free hd space...

I have tried this problems of memory on 3 different PC ( my office , and PC
of Clients ),  and the problem there is always.

Now I would undestand how increase the perfomance of my application... You
have to know the users'll run my application on windows xp pc..



I should have always best performance , with outlook and word open, too.
Wink

Thanks

Tue, Mar 21 2006 2:42 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Antony,

<< I have a table ( local tdbIsamTable , not memory) with filter properties
populate, filtered set true and code in onfilter event. In my application I
open the table and then I analize it by a classic do while loop.

I have understood that if I close all my applications the loop requires
from 3 to 10 seconds but if I leave any applications (
outlook..word...MSN7...Delphi IDE... ) opened it requires 1 minute or more
( HardDisk work much ) ...

I think it depends how dbisam manages the memory allocation for filtered
table and so i have tried fastmm without great results. I'm using a fast
notebook with 1Gb RAM and some Gb free hd space... >>

How much memory is free when everything is open ?  If the OS is running low
on memory and is swapping to disk, there isn't much DBISAM can do about it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image