>>But check your insert statement in original post. It didn't have m.
>
>Ok I tried it again, but first I changed the variable creation lines to reflect the m. :
>
>
>m.lcInFile = "testout"
>m.lcOutfile = "testin"
>
>
>Then I tried the 10k record insert test with the following line as the insert:
>
>
>INSERT INTO (m.lcInfile) FROM memvar
>
>
>It still took 5 seconds to finish
>
>But If I comment out the following line, the 10k recs are inserted in approx. 1/2 second:
>
>
>USE testout IN 0 Exclusive ALIAS MyOUT
>
>
>I'm sure some people may view this whole thread as being a little obsessive on my part (and let me be the first to admit that I AM obsessive ;-), but again, when importing this amount of data, seconds can turn into hours.
What happens if you open the table without the alias MyOUT?