Hi!
I'm not 100% sure, but I think it would be much faster if you use COPY
instead of INSERT when you read in a lot of data from a file.
Regards,
Patrik Kudo
--
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Wed, 18 Apr 2001, Konstantinos Agouros wrote:
> Frankly what matters is the time it takes alltogether. I have a script that
> first does a few million inserts, and than queries on this data... these queries
> don't terminate in a reasonable (<10days) time, if I don't use indices.
>
> So I will add some drop/create index-commands to the script...
>
> Konstantin