| Subject | DB-Inserts slow after 5000 inserts (with select) |
|---|---|
| Author | Jens Saathoff |
| Post date | 2011-06-14T19:06:23Z |
Hi!
In my app i use firebird and the ibpp-c++-api for firebird. I'm
importing data from files. There is an import-routine, that first
checks if a row already exists.
Example: SELECT id From PLAYER WHERE name='thename'
If no record exists and the id returned is 0 i'm inserting the data.
After 5000 inserts the inserts getting slow. I start with 2000 records
in 10 seconds, after 5000 inserts it slows down to 100 records in 10
seconds.
Is the problem the select statement before?
Any suggestions or ideas?
Thank you very much!
In my app i use firebird and the ibpp-c++-api for firebird. I'm
importing data from files. There is an import-routine, that first
checks if a row already exists.
Example: SELECT id From PLAYER WHERE name='thename'
If no record exists and the id returned is 0 i'm inserting the data.
After 5000 inserts the inserts getting slow. I start with 2000 records
in 10 seconds, after 5000 inserts it slows down to 100 records in 10
seconds.
Is the problem the select statement before?
Any suggestions or ideas?
Thank you very much!