I am pumping lines from a VFP program to an SQL server over dial up (using SQL passthrough INSERT).
I'm getting in my given situation about 400 lines per second. Performance is as expected especially determined by the slow connection.
Anyone ideas to speed this up ?
One of the ideas i had is to put the data as a textfile in the servers HD and some stored procedure executing a bulk insert. The problem is how the SP can read the datafilenames in the 'upload' directory. I can't work with one fixed name as different users can upload a file.
Maybe there are better or simpler ideas ?