>I've recently installed VFP9 service pack 1. We are converting an enormous amount of data to fox dbfs. I've always thought that SQL inserts were faster than append blank, and for that matter safer. (FYI, In this particular instance, we are not assigning primary keys to the tables and they are opened exclusively for this operation.)
>
>However when running the code from within VFP 6, it is 5 times faster than in VFP9:
>
>INSERT INTO (lcpath + lcTable) FROM memvar
>
>For 10,000 iterations of this code, VFP9 took almost two minutes, while VFP6 took only 20 seconds.
>
>When I replace the above line with the following, VFP9, now runs as fast or faster than VFP6:
>
>append blank
>gather memvar
>
>What am I missing here????? I'm puzzled.
>
>One other note, I have SET SQLBUFFERING OFF but there must be something else in play here.
Rick,
You might start to test after prefixing all of your memory variables with m.
Cetin