Search found 5 matches

by john_pa3erp
14.10.2005, 15:06
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZConnection refresh issue.
Replies: 2
Views: 1211

Maybe set transaction isolation to ReadCommitted?
by john_pa3erp
10.10.2005, 11:17
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TZQuery opens slow
Replies: 5
Views: 2027

It is not the amount of resultrecords, it is Zeos asking for fielddefinitions. The tracer shows this SQL taking so much time: SELECT a.RDB$RELATION_NAME, a.RDB$FIELD_NAME, a.RDB$FIELD_POSITION, a.RDB$NULL_FLAG, a.RDB$DEFAULT_VALUE, b. RDB$FIELD_LENGTH, b.RDB$FIELD_SCALE, c.RDB$TYPE_NAME, b.RDB$FIELD...
by john_pa3erp
07.10.2005, 20:24
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TZQuery opens slow
Replies: 5
Views: 2027

Hello, we did also some tests and came to the same conclusion. 'qry.open' is very slow with ZEOS. Speed is significantly better with 'ADO' and 'SQLDirect' Disabling the debug define in zeos.inc doesn't change anything. Hi, Well, the first opening anyway. Found another thing using a packetsniffer: Z...
by john_pa3erp
07.10.2005, 14:27
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TZQuery opens slow
Replies: 5
Views: 2027

TZQuery opens slow

Hi ZEOS-team, using D7, FB1.5 via internetconnection. I have created a small testproject with different DBO's, like Borland Interbase, MDO, ZEOS, FBPlus and IBO. Query: select * from TABLE Sequence: Open connection, record time A, Set Query Active, record time B, close Query, close connection, show ...
by john_pa3erp
21.09.2005, 14:03
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TimeOut on TZConnection
Replies: 1
Views: 1303

TimeOut on TZConnection

Hi developers, Occasionnally, the Firebird 1.5 server on W2K I try to connect to hangs. That is: the FB service is still running but the coonection does not get completed. In this case TZconnection does not return from its connect-method and I have to kill the process from the task-list. Is it possi...