Re: php/apache/oracle

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 30 Jun 2007 02:20:16 GMT
Message-ID: <A5jhi.221667$Fk2.88271@newsfe08.phx>

Pauly <darakjia_at_gmail.com> wrote in news:1183151798.622697.18830 @x35g2000prf.googlegroups.com:

> Would anyboby have a good idea of the pros and cons of using php on an

as compared to what alternative

> 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 timout while LONG running SQL to return.

How much data actually gets returned to browser?

> I am also concerned about concurrent queries

Don't worry about concurrent queries.

> 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!

One of my mottos is "First make it work, then make it fancy. IMO, hold off on connection pooling until everything else works AND performance measurments indicate it is justified.

HTH YMMV! Received on Fri Jun 29 2007 - 21:20:16 CDT