Is there a set number of users on your system, where the file names can have like a id number+'mydailydata.txt' have the sp loop thru all the dropped off data daily, hourly, whatever makes sense, and import it all then.
Then remove the dumped files.
Just a thought.
Bob Lee
>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 ?
In the beginning, there was a command prompt, and all was well.