Speed up access to query on HFSQL

Startbeitrag von PETER ZHOU am 16.03.2016 10:19


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 ?




Hi Peter,

If the query is made by the query editor, then you can do a static audit and WX will propose the optimization for the query.


von Piet van Zanten - am 16.03.2016 11:15
Hi Peter,

it depends mostly of the type of conditions you are using on the 4 parameters. IF they are "=", then just create a composite key on the 4 fields

If some are "=" and other "> or

von Fabrice Harari - am 16.03.2016 13:08
Hi Peter

Do you have an index on the fields that you have a parameter on ?

This is not normal behavior. I have records with a lot more rows and with up to 7 parameters . The tables are instantly loaded.

It is important to have indexes on the fields. Does the querie has lots of files? If so, see to it that you have layed all the relations. The querie uses ralations and indexes if they are not set correctly it can take time.



von Allard - am 20.03.2016 15:37
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.