Date:  01/08/2007 02:54:27 PM Msg ID:  003266
From:  Fernando Medan Thread:  003266
Subject:  Problem in Select-SQL
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