Subject Re: [IBO] Query 3 times slower in 5.9 as compared with 4.21
Author Rohit Gupta
Post date 2017-03-28T02:42:01Z
Hi Jason,

I finally have some time to try the cursor.  In the test application, its certainly giving a 10 fold improvement.  When I plug it into production code.  When some sqls  do not return data (ie zero records)  the

eof = false,
bof = true  and
recordcount = 0

Any ideas why.  For other queries, eof is true when the sql returns no records.

Regards

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.