Search found 6 matches

by stOrM!
13.12.2007, 13:52
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: SELECT Statements
Replies: 8
Views: 2325

1) Threading: advanced topic for me... I'm not a real application developer (don't ask what I am 8) ) and I certainly never wrote Delphi applications using threads. Usually the queries are short enough to wait for. 2) I think this are 2 queries... You should use a ZSqlProcessor to process that. Or ...
by stOrM!
13.12.2007, 12:13
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: SELECT Statements
Replies: 8
Views: 2325

Only hope left for me are memory issues. Like memory not being freed at first query destroy. Then later queries might need new memory again maybe on places that are slower to read. (eg. Swap space) Recent versions of zeoslib shouldn't have this kind of memory leaks anymore, however. If I had the da...
by stOrM!
12.12.2007, 16:54
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: SELECT Statements
Replies: 8
Views: 2325

Same delays in MysqlQueryBrowser as well? Tried HeidiSQL? They use zeoslib components, so they should have the same issue if it's a zeoslib bound problem. It's not a problem during close of the first dataset? You could try this by doing a runtime create and destroy of the query (and eventually conn...
by stOrM!
11.12.2007, 15:35
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: SELECT Statements
Replies: 8
Views: 2325

Did you retrieve all records from the first query resultset? (= did you effectively scroll to the end of the recordset or did a recordcount) 0.5 seconds is very quick to retrieve all 16000 records, so maybe the first time you fetch only first XX records while second time all records are fetched. To...
by stOrM!
11.12.2007, 12:24
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: SELECT Statements
Replies: 8
Views: 2325

SELECT Statements

Hello, I wondering about the following which maybe someone can explain: when running a query against a mysql 5 table which contains 16.000 recordsets the very first time (Select * from Tablename) then I got the resultset in 0.568s not bad thought but now the funny part, if I run that query again it ...
by stOrM!
11.12.2007, 12:18
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: MySQL backup component
Replies: 16
Views: 10312

Thats what I was searching for!
You did a great job, maybe you could implement an event so that a progressbar and or time remining value can be shown to the user?

kindest regards
s!