Date:  01/08/2007 04:56:19 PM Msg ID:  003267
From:  FoxWeb Support Thread:  003266
Subject:  Re: Problem in Select-SQL
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):
 
In VFP:
? SYS(3050, 1)
 
 In FoxWeb:
Response.Write(SYS(3050, 1))
 
FoxWeb Support Team
support@foxweb.com email
Sent by Fernando Medan on 01/08/2007 02:54:27 PM:
Hi,
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.

Examples:

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.

 

www.basenet.com.ar
Soluciones integrales para plataforma Internet