FOROS PROFESIONALES
WINDEV
,
WEBDEV
y
WINDEV Mobile
Inicio
|
Mensajes recientes
|
Conéctese...
|
Desconectar
|
Español
Inicio
→
WINDEV (versiones precedentes)
→
WD9 : HFilter vs Query
WD9 : HFilter vs Query
Iniciado por Marius, 24,may. 2006 16:07 - No hay respuesta
Conéctese…
Marius
#1
Publicado el 24,mayo 2006 - 16:07
Hi Everyone
Hope someone can shed some light on the next issue.
Whould there any difference is speed if I use HFilter instead of HExecuteQuery when looping through records on a file server with many users?
I've read several posting on this topic on this forum, but I'm still not sure what to expect.
I've done the following test (1000 records) using both a HFilter and Query and the Query takes longer to process the records. However, there were nobody else using the database on the server during the test.
Time_Start = TimeSys()
HExecuteQuery(QueryHisData,hDefault,113,Null)
HReadFirst(QueryHisData)
WHILE NOT HOut
Trace(QueryHisData.HisDataID)
HReadNext(QueryHisData)
END
TimeEnd = TimeSys()
Info(TimeEnd - Time_Start)
I understand that the HExecuteQuery will send the request to the server and the server returns the request. Does it work differently when using HFilter?
My concern is that if I use HFilter, it might not cope when many users are using the server.
I run many reports and before the report gets printed, many records from many databases are processed and the results are saved in a database which gets printed. This pre-processing time is what takes up resources. I am trying to find the best solution to access those records in the fastest way possible, by using HFilter or HExecuteQuery.
Thanks and Regards
Marius
Informar
0
0
→ Volver a WINDEV (versiones precedentes)
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versiones precedentes)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Búsqueda Tipo
Sólo temas
Todos los mensajes
Periodo Buscar
Cualquier fecha
Última hora
Última 24 horas
Última semana
Último mes
Último año
Cancelar
Vista previa del mensaje
Añadiendo una imagen
Importar una imagen desde una URL
Enviar una imagen desde un archivo de su disco
Arrastrar un archivo o click en "Examinar..."
o
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto