Depending on Search criteria. It could be more than 100000 records or ~ 500 records, if more criteria were specified.
I believe, in case of too many records returned we have to show message asking to refine the Search criteria.
But I'm interested in General approaches here. According to my information, they tried to use SET FILTER and LOCATE to show the data. I was trying to advise against this idea, because I believe, that FILTER is the slowest command in FOX. If we have indexes on each field, I'm sure, that the SQL will take up to 10 sec. in the worst case. So, we have ~45 sec. to show the data.
Can you please give me the info, how you usually approach this problem? I'm a complete newbye in WEB-applications.
>How much data are you returning?
>
>>Hi everyone,
>>
>>We have a Users table with some characteristics. We're trying to run a simple query to put result on the WEB. Each time we get Timeout on the server, because Server can wait only 30sec.
>>
>>What can we do to optimize it?
>
>-Mike
If it's not broken, fix it until it is.
My Blog