Subject | Re: [firebird-support] DB-Inserts slow after 5000 inserts (with select) |
---|---|
Author | Jesus Garcia |
Post date | 2011-06-14T20:31:13Z |
> Hi!Jesus Garcia
>
> 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!
>
[Non-text portions of this message have been removed]