Subject RE: [IBO] Query 3 times slower in 5.9 as compared with 4.21
Author IBO Support List
Post date 2017-03-02T04:13:25Z

I anticipate changing over to use TIB_Cursor will be a big help.

The complexity of the IBO buffered queries is likely a factor.

It might be trying to query metadata or prepare other internal cursors for special function.

Using a TIB_Cursor eliminates any of these other items of overhead.

 

Please let me know and I’m happy to help if you still have trouble.

 

Kind regards,

Jason Wharton

www.ibobjects.com

 

 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Wednesday, March 01, 2017 8:48 PM
To: IBObjects@yahoogroups.com
Cc: Afsal Abdullah; Razal K A; Nada Bashar; Vinod@...
Subject: Re: [IBO] Query 3 times slower in 5.9 as compared with 4.21

 




Hi  Jason,

I have no issues in you TeamViewer/RDP ing in to do it.  The code for these particular applications in not high security.  My concern is just the applications are large.  So before you do that, I will have to make a tiny application.

The queries we are looking at first are just fetching one record,   Sometimes they fetch more but these are all unidirectional.  So it makes sense to use the Cursor.  I will try and use the TIB_Cursor first.  If that's also slow, then I will get back to you after I have reproduced it in a simple application.

Quantitatively, the old application using the old IBO component used to run these queries in 11-14ms.  Now they run in 30-45ms.  There are hundreds of them as the application caches the client, animal, product, staff etc it uses (on demand).  When we enable logging, these are timed from beforeprepare to afteropen.

Thanks

Rohit


On 2/03/2017 06:59, 'IBO Support List' supportlist@... [IBObjects] wrote:

 

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

 

--

Regards

Rohit Gupta
B.E. Elec., M.E., Mem IEEE, Mem IET
Technical Director
Computer Fanatics Ltd

Tel 4892280
Fax 4892290
Web www.cfl.co.nz

This email and any attachments contain information, which is confidential and may be subject to legal privilege and copyright. If you are not the intended recipient, you must not use, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and then delete this email and any attachments.