RE: FoxPro DOS v. Visual Foxpro : Speed of data conversion / processing

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

©1999 Bill Arnold, bill@wjarnold.com