pcsoft.us.windevCopyright 2026, PC SOFT7 Sep 2016 17:07:53 Z1 May 2015 14:03:56 ZI am moving to Windev from a Visual Foxpro environment. The reasons for my move to Windev are that Visual Foxpro is no longer supported by Microsoft and more importantly that there is a maximum file size limit in VFP of 2GB. Some of our customers are nearing that limit on some of their files and they still require to hold more data. I am writing an import routine to move our old VFP data into WD files and I have encountered a problem with the speed of the transfer degrading as the size of the VFP data increases. In my analysis I have a WD file and a VFP file and I am using a simple piece of code that reads a record from the VFP table and writes the record into the WD table. I am using a HFSql client server database and Windev 19. The connection to the VFP file is setup in the analysis using an oleodbc connection. The code looks like this: sFieldList is string = hlistitem(nomtran) hread(VFP_nomtran) while not hout() for each sField in sFieldlist separated by CR {"NOMTRAN." + sField} = {"vfp_nomtran."+sField} end hadd(nomtran) hreadnext(vfp_nomtran) end My problem is that if the initial VFP file starts with 1 million records the transfer runs quickly at 90,000 per minute but if the initial VFP file contains 8 million records the transfer slows down and only runs at 10,000 per minute. Can you explain why this is happening and suggest any ways of improving the speed on the larger files?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Timpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion-59478/read.awp7 Sep 2016 17:07:53 ZHi Ian, I don't know if the following is any faster but maybe it's worth a try: [code:wl] FOR EACH VFP_nomtran HCopyReco…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion-59478/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion-59478/read.awpVFP to Windev data conversioncarlospcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion-59477/read.awp7 Sep 2016 16:11:00 ZHi Ian, I'd like to know your opinión about windev. We also work in VFP and trying to decide to which lenguaje migrate. Than…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion-59477/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51897-vfp-windev-data-conversion-59477/read.awpVFP to Windev data conversion