Subject | Re: [firebird-python] fdb performance |
---|---|
Author | Pavel Cisar |
Post date | 2017-07-11T11:29:51Z |
Hi,
Dne 10.7.2017 v 20:28 at2tce3bx6dxq2hngnxe5xv74qhlsmeghchit7zi@...
[firebird-python] napsal(a):
reason for performance difference as kinterbasdb uses internal
optimization in Cursor to reuse executed statements while FDB does not
(since version 1.4.2, you have to use prepared statements explicitly).
See http://pythonhosted.org/fdb/changelog.html#version-1-4-2
best regards
Pavel Cisar
IBPhoenix
Dne 10.7.2017 v 20:28 at2tce3bx6dxq2hngnxe5xv74qhlsmeghchit7zi@...
[firebird-python] napsal(a):
> Hello,Are you using prepared statement or not? If you don't then it's the
>
> I am finding fdb is 3-5 times slower than kinterbasdb. (Try inserting 100,000 rows into a simple table). Is there any fix for this? I've tried both Windows and Linux clients against Firebird 2.5.4 on RHEL 6.
reason for performance difference as kinterbasdb uses internal
optimization in Cursor to reuse executed statements while FDB does not
(since version 1.4.2, you have to use prepared statements explicitly).
See http://pythonhosted.org/fdb/changelog.html#version-1-4-2
best regards
Pavel Cisar
IBPhoenix