>I can't get back to the thread so here's a new one.
>
>>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 Gateway about the same problem and they had no answer.
>
>It seems the only solution I ran into is to turn the computer off completely. Even doing a warm boot doesn't seem to help. Perhaps NT is still using the same swap files upon a warm boot.
>
>I thought that a defrag would help but the one I looked at requires Service Pack 2 which has messed-up a number of systems so I couldn't\wouldn't use it.
>
>If you get an answer let us know.
>
>Thanks,
>Gene

I left a message about Query complexity. If you need more info....

Tom