>>>Thanks for pointing to this thread. Have you tried both methods? I tested with 382MB text file. Dummy cursor took ~5min. Low-level functions took forever.
>>>Therefore native append from is at least 40 times faster, than low-level.
>>
>>Was the 382MB file on a local hard drive, or a network drive?
>
>Yes, this is probably the source of problem. It is on Network drive. If I have time, I'll try the test with file on local drive.
You probably saturated your network with tens of thousands of requests for little "nibbles" of the great big file.
Be careful, or the netadmin "police" will get you ;-)
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
