Zeoslib Portal

Hi all! I was initially going to post this in user patches or do a ticket, but I realized that I'm not positive that this is a bug, it could easily be something I'm misunderstanding about how things are supposed to work. Also my patched method below is definitely not fully tested. I believe that whe...

Hi All! I'm using Zeoslib 8 and trying to connect to a new MySQL 8 test database on a remote Ubuntu server. I've got everything working the way I think it should, however whenever I try to connect to it I get the error: SQL Error: SSL connection error: unknown error number Code: 2026 Message: Connec...

Hi All! In TZMySQLDatabaseMetadata.detectServerType it is looking for either 'mysql' or 'mariadb' in the results of show variables like 'version' and show variables like 'version_comment'. However, my main test MySQL 5.7 database doesn't actually have the mysql text in the version_comment. It shows:...

That's interesting! I've also noticed that doCachedLobs has no affect. In my testing using the session based setting I see that my query takes much longer to retrieve the result set initially (as expected since now it retrieves the CLOBs at that time) and then accessing the clobs later is super fast...

Are we talking Oracle? As far as I can tell the Zeos Oracle driver doesn't support the CachedLobs option. I see no difference in performance with the setting and it appears that the clob is retrieved anytime the field is accessed (and I see the same network traffic regardless of re-reads.) I also ge...

The connection string I'm using for the OleDB protocol choice is just: Provider=MSDASQL.1;Persist Security Info=False;Data Source=MyDSN MSDASQL is the "Microsoft OleDB Provider for ODBC" and the DSN I'm using is a System DSN setup using the Firebird ODBC driver. Let me know if I've misunde...

> I'm sorry to say this, but it's not about you, nor your request
My wife said the same thing!

-Mark

I just wanted to chime in and mention that since the fix to the dll loading stuff I don't have an actual need for unloading the driver dlls. I really brought it up in case it was something that already existed or something I could use to diagnose/workaround the loading issue. Thanks, as always! -Mark

Thanks for that! I agree on the ADO replacement idea. It definitely seems redundant (more on this in my OleDB specific post.)

-Mark

Thanks for that fix! The change allows me to test using OleDB as a replacement for the ADO protocol and I can report it is very fast and seems to work well with the Firebird ODBC driver. I do agree with your other post that the ADO protocol could be removed and the OleDB protocol used as a replaceme...

I've also just tested the same code using the odbc_w protocol (as suggested by Jan in another post) and that one is blazingly fast. I get 0.1 seconds for opening the query compared to 6 seconds using the ADO driver.

-Mark

Hi Jan, I do use the firebird protocol and it's fantastic. I was testing the ADO protocol and found a performance issue that I mentioned in my other post, so then I attempted to use OleDB to see if it helped and found this issue. Basically I was testing differences between using the ADO and OLEDB Ze...

Hi Jan,

Thanks. I've tried setting ZConn.UseMetadata := False; and it doesn't seem to affect this at all. Is this what you mean by turning off metadata? It was the only setting that seemed to match. Opening and closing the same query multiple times seems to show no gain btw.

-Mark

Here's the create table statement for the test: CREATE TABLE CUSTOMERS ( CUSTOMERID D_IDKEY NOT NULL, CUSTOMERNAME VARCHAR(100), COMPANYNAME VARCHAR(100), BILLINGADDRESS VARCHAR(500), CITY VARCHAR(100), STATEORPROVINCE VARCHAR(100), POSTALCODE VARCHAR(20), COUNTRY VARCHAR(100), CONTACTTITLE VARCHAR(...

I'm using the ADO protocol with a Firebird ODBC driver and having a pretty severe performance issue that seems to be related to retrieving field properties. The following test application takes roughly 6 seconds to run ZQuery.Open;. The same query using Delphi's DbGo TADOQuery object takes .3 second...