Re: php/apache/oracle

Thanks Ana. Please, see my embedded comments ... On Jun 29, 7:20 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> Pauly <darak..._at_gmail.com> wrote in news:1183151798.622697.18830
> @x35g2000prf.googlegroups.com:
>
> > 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

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

>
> How much data actually gets returned to browser?
>

Might be thousands of rows, in which case it will be dumped into a txt file instead of being displayed on the browser.

> > I am also concerned about concurrent queries
>
> Don't worry about concurrent queries.
>

Why do you think I shouldn't be concerned with that?

> > 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 motto is "First make it work, then make it fancy.
> IMO, hold off on connection pooling until everything else works AND
> performance measurements indicate it is justified.
>

OK. I just thought that I should have these things figured out first so that
I don't have to make significant changes in the future (maybe in this case the changes
won't be significant).

> HTH YMMV!
Received on Mon Jul 02 2007 - 13:16:58 CDT