Thanks, but I think that there is no difference in the buffer memory size.
? SYS(3050, 1): 162791424
In FoxWeb (1 Channel)
Response.Write(SYS(3050, 1)) : 168820736
The discrepancy happens when I use fields of characters. The query is very fast with numerical fields.
Does there be any possibility than the Query SQL not be optimized?
Your help is very appreciated.
Sent by FoxWeb Support on 01/08/2007 04:56:19 PM:
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):
|FoxWeb Support Team
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 name="JOHN" into cursor cust1 FoxWeb Script (30 segundos)
select * from customer where name="JOHN" into cursor cust1 VFP windows command (0 segundos)
select * from customer where id_cust=21121 into cursor cust2 FoxWeb Script (0 segundos)
select * from customer where id_cust=21121 into cursor cust2 VFP windows command (0 segundos)
Thanks for your help.