Search found 11 matches

by magrossi
22.06.2009, 16:27
Forum: MySQL
Topic: GetCatalogNames bug
Replies: 2
Views: 445

As much as I think that a command to clear the cache is useful and don't think it should be used in this case. The GetCatalogs functions should always be up-to-date unless specifically told not to. Something like a property "UseCachedCatalogs" should do the trick. I say this because I thin...
by magrossi
08.06.2009, 08:36
Forum: MySQL
Topic: GetCatalogNames bug
Replies: 2
Views: 445

GetCatalogNames bug

Hello, I'm doing an app that needs to delete, duplicate and move a few databases around. It is working as it should but unnexpectedly I started to see a few weird behaviour in my program. I traced them down to the GetCatalogNames function. This function always returns the same thing after you've don...
by magrossi
21.05.2009, 14:53
Forum: MySQL
Topic: Locate extremely slow on ZeosLib components
Replies: 5
Views: 1712

Hi all, I decided to write an external Locate function that takes a TZAbstractDataset as input and all the other parameters of the original Locate function. My method is a simple binary search and thus for can only be used when the dataset is orderer by the fields you are looking for. In a simples t...
by magrossi
21.05.2009, 08:09
Forum: MySQL
Topic: Locate extremely slow on ZeosLib components
Replies: 5
Views: 1712

Hello Mark, I did the testing you proposed and the returned ResultSet is in fact a CachedResultSet. I just ran some other tests and the actual worst case scenario for the ZeosLib Locate method is when the record you are looking for is the actual selected record... Any more ideas to help me fix that?...
by magrossi
20.05.2009, 15:01
Forum: MySQL
Topic: Locate extremely slow on ZeosLib components
Replies: 5
Views: 1712

Hello Trupka,

I'm perfectly aware of the inneficiency of the Locate method compared to doing the Query myself. I would do it if I could. Unfortunately for this project re-writing too much code is out of the question.

Thanks anyway for your time.
by magrossi
19.05.2009, 14:02
Forum: MySQL
Topic: ZConnection.Connect is too slow on my MySQL
Replies: 5
Views: 1055

Hi all, Just to give a feedback on this. I believe this was due to McAfee Firewall interfearance. Although I had it properly configured to allow all traffic to the proper TCP port and all my applications. The problem was solved by full uninstall of McAfee.. Thanks to take the time and answer Mark an...
by magrossi
19.05.2009, 14:00
Forum: MySQL
Topic: BatchMove from ClientDataSet to TZTable?
Replies: 2
Views: 546

Thanks Mark,

I solved this by copying one record at a time. It's not as slow as one would expect and it serves my purpouses.

Cheers!
by magrossi
19.05.2009, 13:57
Forum: MySQL
Topic: Locate extremely slow on ZeosLib components
Replies: 5
Views: 1712

Locate extremely slow on ZeosLib components

Hello, I just stopped by to publish a few results I obtained while comparing the ZeosLib components against regular BDE components. More specifically locating records by key with TTable versus TZTable. Both using the "Locate" function. I was wondering if something can be done regarding the...
by magrossi
28.04.2009, 11:08
Forum: MySQL
Topic: BatchMove from ClientDataSet to TZTable?
Replies: 2
Views: 546

BatchMove from ClientDataSet to TZTable?

Hello, I'm converting some data from an old Paradox database to a new MySQL one and for that I'm using these great ZeosLib components for Delphi 6. Is there any easy way around this, like the BDE's TBatchMove component and/or property from the TDBEDataSet? What happens is that I have a table with ov...
by magrossi
22.04.2009, 14:17
Forum: MySQL
Topic: ZConnection.Connect is too slow on my MySQL
Replies: 5
Views: 1055

I'm not sure. But I find it difficult because I am using "localhost" as my address...
by magrossi
21.04.2009, 11:50
Forum: MySQL
Topic: ZConnection.Connect is too slow on my MySQL
Replies: 5
Views: 1055

ZConnection.Connect is too slow on my MySQL

Hi, I have MySQL 5.1 installed on my Windows 2000, Pentium IV 1.6Ghz 512Mb, machine and I'm using the ZeosLib 6.6.4 (stable) components for Delphi 6 to connect my database. The components work great! Thanks all for this great package! But I'm having an annoying problem. Whenever I call connect from ...