Re: php/apache/oracle

On Jul 2, 4:22 pm, Geoff Muldoon <geoff.muld..._at_trap.gmail.com> wrote:
> Pauly says...
>
> > > > Would anybody have a good idea of the pros and cons of using php on an
>
> > > as compared to what alternative
>
> > As compared to Tomcat/Java/Oracle or IIS/C#/Oracle
>
> Horses for courses. We run both Tomcat/Java/Oracle and
> Apache/PHP/AdoDB/Oracle and both have their pros and cons.
>
> PHP pros: Simple code, easy to develop and deploy
> PHP cons: Weak object model
>
> > > > Apache server to connect to and run queries on an Oracle database. The
> > > > database concerns mostly with genetic data. Therefore, the queries can
> > > > be pretty complex and time-consuming (millions of rows on large number
> > > > of tables).
>
> > > One possible problem is network timeout while LONG running SQL to return.
>
> > Yes, you are right. But in this case I am not sure I have control over
> > it.
>
> PHP has an adjustable timeout setting. You might also have issues with
> max_file_size in both PHP and Apache.
>
> > > > I am also concerned about concurrent queries
>
> > > Don't worry about concurrent queries.
>
> > Why do you think I shouldn't be concerned with that?
>
> No more of a concern in three-tier than in client/server.
>
> > > > and am
> > > > inclined to implement connection pooling so that time can be saved on
> > > > the creation of new connections to the db every time a query is fired.
> > > > Anybody with experience on this? Thanks!
>
> We use the AdoDB library to assist with persistent connections, an
> advantage of it with Oracle/PHP over some other database abstraction
> layers is that it least supports bind variables.
>
> Geoff M

Regarding performance how would you compare Tomcat /Java/Oracle and Apache/PHP/AdoDB/Oracle?

Also, I had started looking into the Tomcat/Java option but gave up after trying to get connection pooling to work. I tried for 3 weeks and just couldn't get it to work. I was using Tomcat 5.5 and Oracle 10g (Tomcat installed in XP and Oracle in Solaris). Received on Tue Jul 03 2007 - 11:38:41 CDT