|Subject||Re: slow inserts with Firebird 1.5.1|
--- In email@example.com, "Arno Brinkman"
> > Did you've indexes on that table and how unique are the inserted
> > values?
> > I meant did you insert many duplicates.
> > There were no indexes and the values were random. Does it matter
> > there are duplicates?index
> Only if there is a index on it. The current (FB1.5 and lower) used
> does a bad job with a lot of duplicates.per
> But, is 20 sec. on 1 000 000 really so slow? That's 50 000 records
> If i understand your message correct then you are already using a
> query, right?table.
> If i'm not wrong the fastest way inserting data is using a external
> When you don't insert NULL states then this is possible.It's 20 minutes not seconds. The query was prepared.