pcsoft.us.windevCopyright 2026, PC SOFT4 Nov 2016 18:02:00 Z30 Oct 2016 19:15:00 ZHi everybody, I am always wondering what is the best practice in getting one record and update few records: hreadseek(file,etc) or do an sql query? Thanks Noel30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60237/read.awp4 Nov 2016 18:02:00 ZFabrice Good explanation. I had not even considered the pre SQL scenario. Bit of a late starter here as WD was already on…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60237/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60237/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60242/read.awp4 Nov 2016 13:55:00 ZHi Derek, Maybe, the bleeding obvious thing is that the hxxx functions existed WAY before they added SQL support. So, my und…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60242/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60242/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60236/read.awp4 Nov 2016 13:00:00 ZNo one really seems to know exactly what 'H' commands do - be nice if PCS gave us some info. Personally I have always believe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60236/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60236/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60234/read.awp4 Nov 2016 12:57:00 ZWith native access if you use H*** functions the native access convert the H** function to SQL. Some of the convertions are n…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60234/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60234/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60233/read.awp4 Nov 2016 11:38:00 ZQuote GuenterP Hi, it depends whether you're using a Native Access or OLE DB or ODBC for access of the db ... Native Access …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60233/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60233/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60235/read.awp4 Nov 2016 10:27:00 ZHi, it depends whether you're using a Native Access or OLE DB or ODBC for access of the db ... Native Access uses H-commands dir…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60235/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60235/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60232/read.awp4 Nov 2016 10:12:00 ZLets say i use MSSQL as database in combination with Windev NativeAccess and i want to read 1 record. What to use ? HReadSeek…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60232/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60232/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60227/read.awp4 Nov 2016 00:28:00 ZUse hreadseekfirst for an exact match read. I agree with Fabrice; in broad terms, use h... functions for singular read/write/…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60227/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60227/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60226/read.awp3 Nov 2016 23:31:00 ZI'd recommend using hfilteridentical if you want to read exact record or set of records. hreadseek looks for first match OR HIGH…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60226/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60226/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60222/read.awp3 Nov 2016 11:54:00 ZThis most compelling reason to use sql is the compatibility with different file systems. Clients might 'grow out' of HFSQL as w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60222/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60222/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60221/read.awp3 Nov 2016 11:38:00 ZOK, maybe no difference on the database server but there is less IO on the network.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60221/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60221/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60220/read.awp3 Nov 2016 11:08:00 ZHi, there is no real difference in time between reading the whole record and reading a few field. The actuator of the hard disk …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60220/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60220/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60217/read.awp3 Nov 2016 10:24:00 ZHi, According to me SQL queries are more universal than Hxxxxx. and this is true in case of migration to another system doing…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60217/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60217/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60219/read.awp3 Nov 2016 09:16:00 ZHreadseek gets the entire record. With SQL you can retrieve only the fields you need.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60219/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60219/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60213/read.awp2 Nov 2016 18:47:00 ZHi Noel. This is just my opinion. VPN can be slow connection for all cases . MyConnection..compresssion = True can make it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60213/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60213/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60206/read.awp2 Nov 2016 12:38:00 ZHi Fabrice and ICI does the same apply when the server is a remote one and working through a VPN? Thanks Noelhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60206/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60206/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60205/read.awp2 Nov 2016 10:02:00 ZHi Noel Best practice, as stated by PCSoft in the help: - read one record: hreadseek - read multiple records: query - upda…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60205/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60205/read.awpBest Practice - hreadseek or sql query?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60204/read.awp2 Nov 2016 09:08:00 ZHi Noel. Hreadseekxxxx() functions are always faster then sql query to find one record at the time, if you have an index on tha…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60204/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60176-best-practice-hreadseek-sql-query-60204/read.awpBest Practice - hreadseek or sql query?