pcsoft.us.windevCopyright 2026, PC SOFT19 Apr 2015 17:28:00 Z8 Oct 2014 07:26:16 ZI've made two different projects with the same code except that one is using a connection to a MySQL database and the other one to HFSQL and the speed when retrieving records using queries with MySQL is about 6 times faster than HFSQL. No matter what it is, retrieving information from the MySQL server takes about 4-5 seconds and HFSQL takes over 25-30 seconds. Is there any specific configuration the HFSQL server needs to be as fast as MySQL? i have both servers with default configuration. NOTE: I'm testing this in a remote server (I'm not interested in local connections)30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-51625/read.awp19 Apr 2015 17:28:00 ZHi Mauricio, I wonder how you solved that? Any progress on speed issue? Regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-51625/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-51625/read.awpHFSQL speed against MySQLshadow.sfx.svpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48432/read.awp12 Oct 2014 19:01:32 ZI did and i posted what i did because i don't think there is "code" to be optimized (and if there is, that is the reason of why …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48432/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48432/read.awpHFSQL speed against MySQLfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48369/read.awp8 Oct 2014 19:23:57 ZHi Mauricio again, you did not read my answer completely... On 10/8/2014 9:24 AM, Mauricio Ramirez wrote: > In my progr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48369/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48369/read.awpHFSQL speed against MySQLshadow.sfx.svpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48364/read.awp8 Oct 2014 17:24:38 ZIn my program all there is, is a window with a browsing table control that i'm filling with this code: [code:wl] IF (HExecut…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48364/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48364/read.awpHFSQL speed against MySQLfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48354/read.awp8 Oct 2014 13:05:34 ZHi Mauricio with so little information, it's hard to say. - your code may need to be optimized for HF - Your analysis may n…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48354/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48345-hfsql-speed-against-mysql-48354/read.awpHFSQL speed against MySQL