PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV (précédentes versions) → WD9 : HFilter vs Query
WD9 : HFilter vs Query
Débuté par Marius, 24 mai 2006 16:07 - Aucune réponse
#1
Posté le 24 mai 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
→ Revenir à WINDEV (précédentes versions)