|
| Speed up access to query on HFSQL |
| Iniciado por guest, 16,mar. 2016 11:19 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 16,marzo 2016 - 11:19 |
Hi,
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 ZHOU |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,marzo 2016 - 12:15 |
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.
Regards,
Piet |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,marzo 2016 - 14:08 |
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 <" then create a composition key with first the equal ones, then the other ones.
If you are doing contains, you are out of luck.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,marzo 2016 - 16:37 |
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.
regards
allard |
| |
| |
| | | |
|
| | | | |
| | |
|