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:
127.0.0.1:/pathto/thedata/test.gdb

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

Thanks,

Tony