pcsoft.us.windevCopyright 2026, PC SOFT8 Mar 2016 19:04:00 Z8 Mar 2016 11:26:00 ZHow 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.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56762/read.awp8 Mar 2016 19:04:00 ZYou might want to look at HFSQLCS views or materialized views which are new in V20. They also use server side queries to build a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56762/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56762/read.awpUsing complicated server side queries on HFSQL C/Sguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56754/read.awp8 Mar 2016 14:39:00 ZThis is not about stored procedures, and concerns only HFSQL CS. As I understand it, the query is defined in the application ca…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56754/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56754/read.awpUsing complicated server side queries on HFSQL C/Sguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56747/read.awp8 Mar 2016 12:56:00 ZHi, Are not ALL queries server side queries? Or are you talking about stored procedures? Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56747/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56742-using-complicated-server-side-queries-hfsql-56747/read.awpUsing complicated server side queries on HFSQL C/S