Search found 6 matches
- 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 ...
- 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...
- 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...
- 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...
- 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 ...
- 11.12.2007, 12:18
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: MySQL backup component
- Replies: 16
- Views: 10312