Hi,
I have an SQLite database that has a field with a unique constraint and I
want to be able to insert records as fast as possible.
The program works fine if I use
insert or ignore into table_name...
but the problem is that the primary key field which has autoincrement option
skips the ID of each record which is not inserted because it is already in
the database, and I don't want that.
So I have also tried using
eval {
... the query...
};
But the perl interpreter crashes and it appears an error window if the query
gives an error.
I think that it would take too much time to verify each record if exists in
the database before inserting it...
Do you have a recommendation for the best way of doing this?
Thank you.
Octavian
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
