I have a Delphi project with a data module that contains a TZConnection component to connect to a MySQL database. When I start working on the project and open the project in Delphi, it takes for about 15 minutes (and this time increases over time) to open the data module file...
During runtime of my project all is fine: the connection is established fast and query performance is also just fine.
Does anybody have any clue what the problem could be? I was thinking of a log file or something getting too large, but that doesn't seem to be the problem. Any help or hint is welcome!
I'm using: Delphi 2005, MySQL 4.1.22 and ZeosLib 6.6.0 beta.
Is it just one TZConnection object or are there more objects?
Do you have an open connection at design time? Are the queries in your project all loading at design time?
I have done some testing: the problem also occurs when I add a TZConnection to a form in a clean project. So, no TZQueries or any related components, just the TZConnection. It now takes up to almost 25 minutes... Very frustrating when you want to start working on a project immediately
Tel us a version of DB server. Where is server? On your computer or in the net?
Probably this is not delphi or zconnect problem.
Can you normaly connect to server with some other program from yor computer?
Database server is MySQL 4.1.22. It runs on localhost. Connecting to the database directly using MySQL Administrator or phpmyadmin is fast. Creating the TZConnection is slow. TZConnection is disconnected by default, so I think this problem is not related to the DB (server).
Maybe a problem when Delphi is looking for the bpl/libmysql.dll files?
Sounds very unlikely, but one never knows. I'm not using D2005, so it could be Delphi version dependent.
Did you try a fresh Delphi install? (bad option, I know, but when software goes mad it may be the easiest solution)
