Re: modperl and SQL db select

2002-03-21 Thread Marc Slagle
> Is there any issue with using modperl with postgres vs mysql > for a database driven website? Don't want to bark up the wrong > tree in a mod_perl project only to discover I picked the wrong .db :-/ http://www.mysql.com/news/article-91.html This was an interesting article, even though it didn'

Re: modperl and SQL db select

2002-03-21 Thread Tom Mornini
On Thursday, March 21, 2002, at 01:05 PM, Dave Rolsky wrote: >> Further on, he was discussing threaded discussion forums and assumed a >> recursive query. While recursing the DATA is probably (though >> provabably not >> always) necessary, there is no need to storm the db with that many >> quer

Re: modperl and SQL db select

2002-03-21 Thread Michael Peppler
Jay Thorne writes: > > Okay, now I need an example. I've never seen a query on any db where a single > table query was slower than a two table join. Of course, I'm biased here, > since my knowledge of the more bizarre db's is limited. I've only seen things > like sybase, oracle, mysql, po

Re: modperl and SQL db select

2002-03-21 Thread Ged Haywood
Hi all, On Thu, 21 Mar 2002, Perrin Harkins wrote: > > Please, please, please KILL THIS THREAD! I second that. It's all been done before guys. 73, Ged.

Re: modperl and SQL db select

2002-03-21 Thread Perrin Harkins
Please, please, please KILL THIS THREAD!

Re: modperl and SQL db select

2002-03-21 Thread Jay Thorne
On March 21, 2002 01:05 pm, Dave Rolsky wrote: > On Thu, 21 Mar 2002, Jay Thorne wrote: > > The first one I noted was that he assumes that a high performance app has > > several joins. I think everyone here who's developed a few db apps will > > tell you that joins are hugely costly and should be

Re: modperl and SQL db select

2002-03-21 Thread Dave Rolsky
On Thu, 21 Mar 2002, Rafiq Ismail (ADMIN) wrote: > Mysql:+we all start with it. > +Bench marks much faster. > +/-Can allow nested queries (subselects again) though this is a > relatively new feature. Eh? Subselects aren't scheduled for implementation until 4.1. The

Re: modperl and SQL db select

2002-03-21 Thread Dave Rolsky
On Thu, 21 Mar 2002, Jay Thorne wrote: > The first one I noted was that he assumes that a high performance app has > several joins. I think everyone here who's developed a few db apps will tell > you that joins are hugely costly and should be avoided for an application's > most common cases. Act

Re: modperl and SQL db select

2002-03-21 Thread Rafiq Ismail (ADMIN)
Postgres: +More relational? So they say. More features perhaps. +stored procedures - ie. you can make query wrapping methods -pain the rear postgres user permissions to control. +been doing complex sql queries (subselects etc,) for longer. +Rem

Re: modperl and SQL db select

2002-03-21 Thread Jay Thorne
On March 21, 2002 10:37 am, darren chamberlain wrote: > Quoting Dave Hodgkinson <[EMAIL PROTECTED]> [Mar 21, 2002 13:25]: > > darren chamberlain <[EMAIL PROTECTED]> writes: > > > Quoting dreamwvr <[EMAIL PROTECTED]> [Mar 21, 2002 13:10]: > > > > Is there any issue with using modperl with postgres

Re: modperl and SQL db select

2002-03-21 Thread darren chamberlain
Quoting Dave Hodgkinson <[EMAIL PROTECTED]> [Mar 21, 2002 13:25]: > darren chamberlain <[EMAIL PROTECTED]> writes: > > Quoting dreamwvr <[EMAIL PROTECTED]> [Mar 21, 2002 13:10]: > > > Is there any issue with using modperl with postgres vs mysql > > > for a database driven website? Don't want to ba

Re: modperl and SQL db select

2002-03-21 Thread Dave Hodgkinson
darren chamberlain <[EMAIL PROTECTED]> writes: > Quoting dreamwvr <[EMAIL PROTECTED]> [Mar 21, 2002 13:10]: > > Is there any issue with using modperl with postgres vs mysql > > for a database driven website? Don't want to bark up the wrong > > tree in a mod_perl project only to discover I picked

Re: modperl and SQL db select

2002-03-21 Thread darren chamberlain
Quoting dreamwvr <[EMAIL PROTECTED]> [Mar 21, 2002 13:10]: > Is there any issue with using modperl with postgres vs mysql > for a database driven website? Don't want to bark up the wrong > tree in a mod_perl project only to discover I picked the wrong > .db :-/ Take a look at http://www.phpbuild

modperl and SQL db select

2002-03-21 Thread dreamwvr
hi, Is there any issue with using modperl with postgres vs mysql for a database driven website? Don't want to bark up the wrong tree in a mod_perl project only to discover I picked the wrong .db :-/ >From a licensing perspective which one is less risky if doing some work for a client? No