>>I have a large database (800Meg, 600,000 records). After an indeterminate number of queries (which go really fast, under 2secs), the next query can take 5-10 minutes. When this is happening, I can see 100s (as many as 800) of page swaps per second using Performance Monitor. Using Task Manager I can see that all 128M of ram is used as well as all 90M of swap space. It appears that some MAJOR thrashing is going on.
>>
>>I am using a Pentium Pro 200, 128M RAM, Two 2-gig Ultri SCSI-3 drives on Windows NT Server 4.0. I have two 45M swap partitions, one on each HD. These do NOT use disk mirroring. The rest of the space on the two HDs is set up using NT disk mirroring.
>>
>>I called MS Tech support for help, but they said they won't help me and to read the article, "Set Turbo On: How Visual FoxPro Memory Usage Affects Performance," in the February, 1997 issue of FoxTalk. I do not subscribe to this so not much help there. I already called the publisher and they couldn't help me (office just moved and nothing was there or some such).
>>
>>I guess I don't have all my Fox Parameters for swap set up and don't know enough about it to fix the problem. Perhaps there is some OS stuff I could do too.
>
>Is the slow query a complex single query? In VFP we have been noticing that multiple simple queries execute much faster then a single complex query.
>
>HTH,
>Tom

its a simple SELECT with 3 tables involucred (JOIN)

ex: SELECT * from table1, table2, table3 where table1.client= table2.client AND table2.client=table3.client

its more specific my SELECT but this....

in FOXPRO 3 it do in 3 Mins and in VFP 5 it do in mor than 30 mins.... :(
i dont know what can i do....

thnks 4 reply
Ariel