Author: Bill Arnold, bill@wjarnold.com
Posted: 1999-08-29 at 23:27:13
Russ, the low level file functions would speed things up if they could
target a table, but having to do APPEND BLANKs kills it, for some reason
that I don't understand. Even without indexes, the operation crawls. I don't
remember where I saw it, or perhaps I'm just making it up, but there
shouldn't be any reason why a 'low level' routine (maybe this would be a
good use for C) can't load a .dbf table (mimicking header and stuff).
Imagine loading tables with the speed of, say, PKZIP?
Bill
-----Original Message-----
From: profox@leafe.com [mailto:profox@leafe.com]On Behalf Of Russ Scott
Sent: Monday, August 30, 1999 1:20 AM
To: Multiple recipients of ProFox
Subject: RE: FoxPro DOS v. Visual Foxpro : Speed of data conversion /
processing
Thanks for the input, Bill:
Since the data would probably require a couple of steps' worth of massaging
I was planning on a blanket APPEND FROM ... TYPE SDF then continuing from
there (I'm not sure, not having seen the whole project) unless I learn that
low-level file functions are significantly faster. Unless they want to
change from FPD, I don't get any .DBC capabilities, either, so a middle
step of massaging seems likely anyway.
Russ Scott
russsct@ix.netcom.com