>Hi, all,
>I have a VFP6 application with about 4Gb data stored, of coz not in a single table. Some user complained that sometimes the application runs very slow. After the investigation, I found the Rushmore is disabled due to insufficient memory, so the
s just take all the network bandwidth to do its job, slow down performance in all workstations.
>The problem is, I don't know when the memory drys up and the Rushmore is disabled, so I can't do anything about it.
>Any experience about that and any suggestion? TIA.
Rushmore itself may consume a lot of memory. How many records does the table in question have? For a clause like (Condition1) AND (Condition2) AND (Condition3), assuming it is fully optimizable, Rushmore creates a "bitmap", that is, a map in memory with one bit for each record (and each of the conditions). In this example, a fourth copy is required for combining the results (with the equivalent of BITAND).
However, Windows programs will usually use virtual memory (hard disk) if real memory (RAM) isn't enough. Perhaps you should just have enough free disk space?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)