Assuming that it all runs on the same server, the discrepancy between running your first SQL statement in VFP and FoxWeb can only be attributed to the buffer memory size. FoxWeb 3.X divides the buffer memory size value that you specified in the FoxWeb Control Center, between the number of running channels. For example, if you specify that you want a total of 900 MB and 3 channels, each channel will be configured to use up to 300 MB of buffer memory size. You can compare the values in each environment by checking the value of SYS(3050, 1):
Sent by Fernando Medan on 01/08/2007 02:54:27 PM:
Currently I am using FoxWeb 3.1 / VFP 6.
I am having problems in SQL query with a table of 250.000 records:
The FoxWeb script with field of characters delays 30 seconds, with a numeric field delays 0 second.
The fields are indexed in the two cases.
select * from customer where id_cust=21121 into cursor cust2 FoxWeb Script (0 segundos)
Thanks for your help.