Subject | Re: Just a few words about Firebird 3.0 performance. |
---|---|
Author | |
Post date | 2016-06-10T13:57:33Z |
>no, it's not faster. FYI, gbak uses 1 transaction to restore the wholeMaybe, but it works on exclusive mode - no other connection can be made to database. I think that this is a special case.
>table, and this is the fastest way to insert data.
I am no expert but I've learned like 10 years ago that in multiuser environment short transactions are preffered.
>seems that you have something in your application, that buffer recordsIndeed I've mixed commiting transaction with closing it. In my test I am making commit per 100 rows and closing transaction after 10000 rows.
>that are inserted, so, the more inserts, the slower process.