Slow query Zeos 8 and Oracle

[rvk]

A query I used as an example performs some joins between tables to compile information from customers' open invoices. It only returns 3 records because I am using a specific client as an example just to test this query (Using Query.Last).

And ZeosLib takes 37 seconds to retrieve those 3 records?
Or did you not test both with the same dataset? 
Otherwise you can't compare them.

(Still think you are testing SQLdb with the wrong thing but you'll discover that when you have migrated )

[babycode]

RVK

The same query in both, the same SQL, the same DB, the same connection configuration without any extra parameters. Practically just changing the library (Zeos/SQLDB). I even did something more generic by returning all costumers (select * from costumers) with no line limit or any other limitation. The numbers obtained (time) were unfortunately equivalent.   

[rvk]

Yeah... if you get 37 seconds with Zeos for just 3 records then there is definitely something wrong, regardless over what kind of connection.

(Glad I'm not using ZeosLib  )

[babycode]

Are you using SQLDB or something else?

[rvk]

Are you using SQLDB or something else?

I normally use the Firebird database so I'm using IBX.
(But my main program is in Delphi/IBX. On Lazarus I normally dabble with SQLdb and IBX.)

Before version 8 ZeosLib didn't support multiple transactions per connection. So I never considered ZeosLib just because of that. Since version 8 you can use multiple transactions per connection on drivers that support it, but that's only Firebird. Oracle itself doesn't support multiple transaction over one connection and if you do use more in ZeosLib, for each transaction, a separate connection is opened !!