Posted by Rick Emery on 08/24/05 15:26

Quoting Nathan Tobik <nathan.tobik@vigilantminds.com>:

> <snip>
>
> Have you tried PHP 4.x? Give that a shot and see what effects that has
> on the application.
> </snip>
>
> We have used PHP with IIS and SQL Server like you said, I can say from
> experience that PHP 5 had the same problems as the initial poster
> described. The pages would time out and hang randomly. I put a 4.x
> version of PHP on the machine and it's been working ever since.

That will probably be our next step (once I rewrite the XML portions of
the application). It's encouraging that it fixed your problem.

> Also if you plan on using PHP with SQL Server and Linux we have been
> using 5 with no problems for over a year now. It gets pretty heavy use
> daily.

I just checked the uptime of the linux machine that's currently hosting
the production app (which is an old desktop machine we had sitting
around gathering dust; a Pentium III 800 w/256MB RAM, and is handling
the load perfectly); 54+ days of 24/7 operations, and still going
strong.

> The only gripe I have is FreeTDS only allows one connection at a
> time, I'd love to use a JDBC driver with PHP. We're looking at using
> PHP and Hibernate which would let us use JDBC.. Best of luck.

I managed this with PEAR's Cache_Lite package. When the first client
requests the data, the server app hits the database once and stores the
data in a cache. Every subsequent request gets its data from the cache,
until it expires 30 seconds later. Then the pattern repeats. So only
one DB connection works fine for us.

Thanks,
Rick
--
Rick Emery

"When once you have tasted flight, you will forever walk the Earth
with your eyes turned skyward, for there you have been, and there
you will always long to return"
-- Leonardo Da Vinci

[Back to original message]