|
| VFP to Windev data conversion |
| Iniciado por igkimberley, 01,may. 2015 14:03 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 01,mayo 2015 - 14:03 |
I 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? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,septiembre 2016 - 16:11 |
Hi Ian,
I'd like to know your opinión about windev. We also work in VFP and trying to decide to which lenguaje migrate.
Thanks in advance.
Regards, |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
34 mensajes |
|
| Publicado el 07,septiembre 2016 - 17:07 |
Hi Ian,
I don't know if the following is any faster but maybe it's worth a try:
FOR EACH VFP_nomtran
HCopyRecord(nomtran,VFP_nomtran)
HAdd(nomtran)
END |
| |
| |
| | | |
|
| | | | |
| | |
|