Subject | RE: [firebird-php] Win2003 Vs Win2k performance?? |
---|---|
Author | Alan McDonald |
Post date | 2004-02-25T05:29:07Z |
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.
Alan
[Non-text portions of this message have been removed]
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.
Alan
[Non-text portions of this message have been removed]