pcsoft.us.windevCopyright 2026, PC SOFT20 Nov 2014 14:41:00 Z19 Nov 2014 14:17:00 ZHi all, Do stored queries improve the speed of the query (on HFSQL)? Thanks Sarah30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49086/read.awp20 Nov 2014 14:41:00 ZHi Sarah, Looking at your posts you are trying to gain speed with HFCS on a cloud vps. In that case the internet speed is th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49086/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49086/read.awpStored Queriesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49077/read.awp19 Nov 2014 23:09:00 ZHi Sarah There is a difference between a stored procedure (that contain the execution of several queries and some extra proce…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49077/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49077/read.awpStored Queriesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49066/read.awp19 Nov 2014 18:22:00 ZNormally yes. They use the processor. memory, disk of the server. They only return some of the data after the selection, order…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49066/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49066/read.awpStored Queriesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49065/read.awp19 Nov 2014 18:13:00 ZHi, I think. Stored queries are running on server side and back result to client. If it is like declared then stored queries a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49065/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49045-stored-queries-49065/read.awpStored Queries