Rohit,

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.

Thanks,
Jason Wharton


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Sunday, February 26, 2017 7:20 PM
To: IBObjects@yahoogroups.com
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 ?


Regards


Rohit




------------------------------------
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.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------

Yahoo Groups Links