Milan,
I have now installed the isapi module (not in filters but only in the
application - readme file suggested it wasn't required if no using http
authentication which I don't) and it appears to make a huge difference. I
also, for some reason, had to put a full path in the extension_dir setting
in the php.ini file - I wonder if the relative path I had before was causing
a problem.
Why don't you set a full path first in your setup (if not already) and test
that before trying the isapi version. As I say - it's all as expected now in
terms of speed of response - it matches the cgi setup speed on my win2003
server
Alan
-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: Wednesday, February 25, 2004 11:33 PM
To: firebird-php@yahoogroups.com
Subject: Re: [firebird-php] Win2003 Vs Win2k performance??


Alan McDonald wrote:

> I have discovered that the first connection to the database is the
> problem. When I open isql and connect, everything works great from PHP
> while isql is connected. As soon as I disconnect with isql, it works for
> few pages and then I get the problems again.
>
> So I made the conclusion that there is some problem when FB is attaching
> the database file. But I don't know how to solve it. Right now, the
> server has always one isql connected, and everything works, but I
> consider that "a dirty hack", not a solution.
>
> Can you please try it, and tell us if it is the same problem.
>
> [Alan McDonald] Not sure about this - otherwise it would be slow on

every

> page. Since each page makes a separate connection and work in the page

is

> coarried out on that connection, then the connection is dropped. I do

not

> experience speed issues on each and evgery page, only when hiting a page
> after letting site lie idle for a few minutes.

Well, it is very similar. Can you please just try to connect with isql,
and stay connected, and then see if you still have problems. Please.

--
Milan Babuskov
http://fbexport.sourceforge.net



Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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