Subject Importing Data Question?
Author mp527
Does anyone know the fastest way to import data from a text file?
Is it significantly faster to connect locally vs from the network

I am currently importing about 20,000 records and it takes about one
hour or so using a tcp connection running on the same server.

i.e my kylix app connection string looks like this:

I tried the ibdatapump product and it does something with exclusive
access and can import 4000 records in a couple of seconds.