PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Query running slow
Query running slow
Iniciado por bbnicu, 22,feb. 2016 08:12 - No hay respuesta
Publicado el 22,febrero 2016 - 08:12
Hello, i have a simple table with 4 records in it .
If i run on hyperfileSql select * from table , it instantly loads results.
If i make a simple query in query editor in windev and i run same query , it loads results in 3-4 seconds,
same thing is happening if i type:


hct_order is Data Source
str_order is string =" select * from table "

HExecuteSQLQuery(hct_order,str_order)
HReadFirst(hct_order)
WHILE NOT HOut(hct_order)
hreadnext(hct_order)
End

It takes same time to show the results.