Stored Queries

Startbeitrag von Sarah Tanti am 19.11.2014 13:17

Hi all,

Do stored queries improve the speed of the query (on HFSQL)?



I think. Stored queries are running on server side and back result to client.
If it is like declared then stored queries are faster and little network hungry.

von ICI - am 19.11.2014 17:13
Normally yes.
They use the processor. memory, disk of the server.
They only return some of the data after the selection, ordering and so on.

If your query return all or almost all the information of the file you wont see any relevant improvement.

von Paulo Oliveira - am 19.11.2014 17:22
Hi Sarah

There is a difference between a stored procedure (that contain the execution of several queries and some extra processing) and just a stored query...

In the first case, you will avoid the back and forth between client ans server and just get the end result, so you will save some transport time. So YES

In the second, if you store only ONE query and return the result, then it's basically the same:
- stored or not, the query is executed on the server
- stored or not, the result is sent to the client
so NO....

As usual, it all depends of what you are doing

What you should do to optimize your application (as it seems that your questions all go in that direction) is review the LOGIC of your application to minimize the manipulation and transfer of data that is not really useful:
- Use more specialized queries with ONLY the fields needed
- Do NOT fill your tables by default, wait for the user to enter selection criteria and return therefore a smaller dataset
- etc...

Best regards

von Fabrice Harari - am 19.11.2014 22:09
Hi Sarah,

Looking at your posts you are trying to gain speed with HFCS on a cloud vps.
In that case the internet speed is the bottleneck.
You can probably gain some speed by using compression (set the Connection..Compression property to True)


von Piet van Zanten - am 20.11.2014 13:41
Zur Information: 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.