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.

Can anyone out there help me?

- Will Schmidt
schmidt@apex-it.com