Installed Firebird 1.0.3 now; seems a little bit better but still goes
up to 1.5-2 secs sometimes.
The problem with the first SQL statement intrigues me too.
Normally the first SQL statement I do on that page (after setup of the
connection and transaction) is the following:
SELECT LSTNAMEADDRESSCAT.ID FROM TABSYSSESSIONLIST LEFT JOIN
LSTNAMEADDRESSCAT ON TABSYSSESSIONLIST.ID=LSTNAMEADDRESSCAT.ID WHERE
SESSION='..' AND LIST='0' ORDER BY LASTNAME, FIRSTNAME;
When it comes as the first SQL statement it takes about 0.35 sec to
execute. First I thought there was something wrong with it, but I
couldn't find anything.
But then I found out that, if I put a very simple SQL statement first
(something like SELECT ID FROM TABLE;) and the one above as the second
one, the one above takes only about 0.05 seconds to execute. But then
the simple first one takes more then 0.3 secs. Anyone has a clue?

Marc

[Alan McDonald]
I say again - have you tried all this using "connect" and not "pconnect"
Alan

[Non-text portions of this message have been removed]