mysql and delphi 7 - transactions, speed etc.

mmikac · Post by **mmikac** » 02.06.2006, 00:47

I am using ZeOS in Delphi to access mySQL database remotely (located on my web/db server). It connects OK and works, but... IT IS SLOW

How can I speed it up?

Could I optimize it by disabling AutoCommit? I tried, but get exceptions when trying to commit manually in my code...

Post by **mdaems** » 02.06.2006, 08:16

First check network speed. Is connection using the mysql client equally slow or not.
Secondly : only select the data you need. Every byte has to be interpreted,cached,...
Tertio : If you only need readonly access, use a TReadOnlyQuery
Quatro : If you don't need components ('batch program') you can try to use the DBC layer immediately Information about this should be in the knowledge base.

Mark

zippo · Post by **zippo** » 03.06.2006, 11:58

Why using TReadOnlyQuery improves speed?

dragondz · Post by **dragondz** » 03.06.2006, 15:04

is your Mysql DB under windows system or Linux?

Post by **mdaems** » 03.06.2006, 20:38

Zippo,

Sorry, It's just a guess, but if ZEOS is written logically (I hope, and if it's not we should change this) There's no need to check if updates to the database should be done. I also think there's less need of memory to cache updates an so on. But : I did not verify this.
Anyhow : don't use a canon to kill a fly.

Mark

zippo · Post by **zippo** » 05.06.2006, 12:53

What about a harpoon?

:):):)

But you planted the seed for curiosity.. I'l test it when I will have time.