pcsoft.us.windevCopyright 2026, PC SOFT20 Mar 2016 16:37:00 Z16 Mar 2016 11:19:00 ZHi, I have a query having around 10,000 records in a database based on 4 parameters ( btw, the parameters are all integer data type). It will take around 50 to 60 secs to do the filter based on these 4 parameters and display it on a table ( table data source is to this query ) even on the local computer accessing it. How to speed up the access to the query ? There's no sort on the query, should i do the sort on these 4 parameters ? Regards, PETER ZHOU30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql/read.awpSpeed up access to query on HFSQLmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56918/read.awp20 Mar 2016 16:37:00 ZHi Peter Do you have an index on the fields that you have a parameter on ? This is not normal behavior. I have records wit…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56918/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56918/read.awpSpeed up access to query on HFSQLRe: Speed up access to query on HFSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56861/read.awp16 Mar 2016 14:08:00 ZHi Peter, it depends mostly of the type of conditions you are using on the 4 parameters. IF they are "=", then just create a …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56861/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56861/read.awpSpeed up access to query on HFSQLRe: Speed up access to query on HFSQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56855/read.awp16 Mar 2016 12:15:00 ZHi Peter, If the query is made by the query editor, then you can do a static audit and WX will propose the optimization for t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56855/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56854-speed-access-query-hfsql-56855/read.awpSpeed up access to query on HFSQLRe: Speed up access to query on HFSQL