INSERT IN TO is faster, fewer locks for one thing, and INSERT .. FROM ARRAY

would probably be faster still.

-Anders

----- Original Message -----

From: Bill Arnold <bill@wjarnold.com>

To: Multiple recipients of ProFox <profox@leafe.com>

Sent: mÃ

’ndag den 30 augusti 1999 08:27

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

processing

| 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

|

|

|

|