I am using FoxWeb 1.2x running on NT with IIS4 and VFP6.

 

I have created an SQL to search from a table with 500,000+ records. The table is stored in the same NT server where FoxWeb is installed. Unfortunately, FoxWeb returned "timout" error for every keyword search.

 

Is there any other method that can make FoxWeb handle huge data records faster?

 

TIA