|
| Using complicated server side queries on HFSQL C/S |
| Iniciado por guest, 08,mar. 2016 11:26 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 08,marzo 2016 - 11:26 |
How to solve the problem when I have a query that runs on a large set of data, using many other serverside queries, tables and functions, and returns a (relatively) small set of data?
On MSSQL server there is a simple solution, I create the complicated view on the server, Importing it in Analysis and use as a normal table.
The question is how is the best and most practical way to solve such a problem on HFSQL C/S? What are my options for best performance?
I would like to have such a query in Analysis and use it in the same way as a table (but read-only).
Can serverside query in some way be used as a classic table of analysis? (on HFSQLCS database)
Thanks,
I hope I have clearly enough explained what bothers me. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,marzo 2016 - 12:56 |
Hi,
Are not ALL queries server side queries? Or are you talking about stored procedures?
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,marzo 2016 - 14:39 |
This is not about stored procedures, and concerns only HFSQL CS.
As I understand it, the query is defined in the application can not refer to other queries, or source queries must been executed beforehand.
Help topic: "Queries based on queries"
If I define a complicated query within the application, then I generate a lot of unnecessary traffic between the servers and applications, especially if the query is based on many other querys. And I do not want that, I want only the final resultset to be returned.
This is how things works when you import a view in analysis, from e.g. MSSQL. I want to do the same on HFSQLCS.
Maybe I do not understand the difference between a query defined in the application and query defined in the analysis, physically located on the server. (I'm talking about HFSQL CS)
On the other hand, if the query is defined only on the server it is not visible in code?!?
It would be good to have the ability to import Query defined on HFSQL server, as we can with MSSQL or MySQL views.
I hope I have better explained the problem. English is not my native language .... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,marzo 2016 - 19:04 |
You might want to look at HFSQLCS views or materialized views which are new in V20. They also use server side queries to build a view and can be used to minimize client/server traffic when using queries based on queries. But be warned, they come with their own quirks. For example a view that has a calculated field, the field will not have correct representation in the analysis making the view un-usable, so no calculated fields in a view.
Another solution is to create a new file to hold the view, then a stored query and stored procedure to refresh data in the table. You would use HExecute to refresh the table when needed..
Dave. |
| |
| |
| | | |
|
| | | | |
| | |
|