Sorry I didn't answer that one, but everything with ibase_connect yes.

--- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> 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]