Subject RE: [IBO] Query 3 times slower in 5.9 as compared with 4.21
Author IBO Support List

That is a rather large jump in versions of IBO so it could be any number of
things causing this.

Would you be able to have me do a remote support session?

I'm sure I can get things working more as you are used to before.

Also, is it possible you can use a TIB_Cursor for that query?
This would eliminate many other possible things because it is simple
unidirectional access without all of the buffering overhead.

PS. I apologize for my delay in responding.

Jason Wharton

-----Original Message-----
From: []
Sent: Sunday, February 26, 2017 7:20 PM
Subject: [IBO] Query 3 times slower in 5.9 as compared with 4.21

We have just upgraded IBO from 4.21 to 5.9. We are finding that even
the simplest of queries (such as fetch one record using primary key) is
3.5 times slower than before.

This happens whether we use FB 1.5 or FB 3.0.1

I have looked at published properties and cant see any differences. Any
clues anyone ?



Posted by: Rohit Gupta <rohit@...>

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more ! - your portal to submit and monitor bug reports - your portal to purchase and upgrade

Yahoo Groups Links