OK I've tested both local and remote connection to the db while hitting the
website. There is no difference between that and not being connected while
hitting the website
I even have one page which is a PHP page with absolutely no db connection in
it - in fact it's pure html with the php extension. It too is slow to load
after leaving the website dormant for a few minutes, consecutive hits on the
same page is much faster (acceptable). So my conclusion is that it is the
speed of loading the php.exe and dll script engine and that it has little or
nothing to do with fb connection speeds.
Again - I suspect IIS5 - IIS6 and the same php setup does not show this
trademark.
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]