Search found 12 matches

by dragos
26.05.2008, 17:11
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Performance breakdown with MySQL 4.1?!?
Replies: 23
Views: 4802

Concerning the documentation files in the distribution : I need somebody to explain me how to easily edit the xml files used to generate these. It's some docbook format, but when I have to edit them using notepad, I refuse to do so. :evil: So if somebody can show me a good (free) tool to edit these...
by dragos
26.05.2008, 11:57
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Performance breakdown with MySQL 4.1?!?
Replies: 23
Views: 4802

So if I understand it correctly the issue seems to be related to caching (TZQuery caches data, TZReadOnlyQuery doesn't and on sorting there is a performance penalty when calling the mysql library). If the problem isn't fixable (maybe that's the way it is supposed to work) then we could at least ment...
by dragos
22.05.2008, 10:13
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Performance breakdown with MySQL 4.1?!?
Replies: 23
Views: 4802

Here is the attached test project (C++ Builder 6). It has a Readme.txt describing how to build it. Someone please test it and confirm the issue. Or just use the database and replicate the application in Delphi (it is very simple). OT: I'm using another user because I've just been locked out of the o...
by dragos
22.05.2008, 07:50
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Performance breakdown with MySQL 4.1?!?
Replies: 23
Views: 4802

OK, I prepared the test application (and simplified it in the process).
Compressed it's 29KB w/o libmysql41.dll and 483KB w/ libmysql41.dll.
It's a C++ Builder 6 application.

Now what do I do with it?
by dragos
21.05.2008, 15:45
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Performance breakdown with MySQL 4.1?!?
Replies: 23
Views: 4802

Yes the thread is old. I was browsing the forum looking the things that happened to me and possible fixes( after seeing gto 's thread with duplicate entries that fixed one of my oldest annoyances that I was too lazy to search/fix for myself - I'm mostly a C++ guy...). I have modified a test applicat...
by dragos
20.05.2008, 14:48
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Performance breakdown with MySQL 4.1?!?
Replies: 23
Views: 4802

Is there a performance difference between TZQuery and TZReadOnlyQuery? Or what makes TZReadOnlyQuey different in comparison with TZQuery, when handling results or requests? Yes there is if you sort the data using the query! I had an application using a TZReadOnlyQuery to populate a TDBLookupComboBo...
by dragos
19.05.2008, 17:18
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Duplicate result when using locate, loPartialKey and Filter
Replies: 7
Views: 2125

This also fixes a bug with a TDBLookupComboBox whose data comes from a TZQuery's dataset where scrolling up/down would - under some conditions - seem as if all entries are duplicates.

Thanks gto!
by dragos
13.01.2006, 09:11
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4510

I'm using TZReadOnlyQuery.... I think it's faster because it's "read only". or not ? :oops: If you're using large SELECT s, TZQuery w/ RequestLive will be faster (my experience some time ago - maybe now it is different). And the explanation had something to do with the way qry.Next() and ...
by dragos
12.01.2006, 12:07
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4510

I understand, but does the RequestLive option make a difference?
by dragos
11.01.2006, 16:11
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: speed of select
Replies: 19
Views: 4510

Try setting TZQuery's RequestLive option to TRUE (I assume you're using a TZQuery).

If it works (i.e. it takes less than 15'), I'll then tell you why :-)
by dragos
27.09.2005, 18:39
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Failed installation on C++ Builder 6
Replies: 1
Views: 2240

C++ Builder troubleshooting FAQ - ToolsAPI (DesignIntf.dcu) - oledb.h & Zplaindblibdriver/Zplainado(DBROWCOUNT, ConnectionEventsVt, RecordsetEventsVt) - stdio.h & ADO (EOF) - include/lib paths 1. I get '[Pascal Fatal Error] ZPropertyEditor.pas(49): File not found: 'DesignIntf.dcu' under C++...