See if cleaning up your code makes a difference. Remember that fox code is interpreted and is not optimized. It is best to leave any counting and comparisons up to the database engine. These changes will speed up your fox code.

******

hnd = sqlstringconnect(...)
=sqlsetprop(hnd, "transactions", 2)  && manual transactions

* the following is moved outside of the loop
csql = "insert into table (field1, field2, field3, ...) " + ;
   "values (?localtable.field1, ?localtable.field2, ?localtable.field3, ...)"

select localtable

do while !eof()

    scan next 2000 && let fox count for you
        =sqlexec(hnd, csql)
    endscan

    =sqlcommit(hnd)

enddo