1

(6 replies, posted in Programming)

a newer "benchmark", altough the load is yet too light: http://benchw.sourceforge.net/benchw_results_open3.html
using the newest beta version of each Database.

Rickard wrote:

You can use the insanely fast MyISAM if you don't need e.g. foreign keys or row-level locking.

i *must* disagree on that, but for me an RDBMS ( lil'troll says: "assuming mySQL would qualify as such" ) must be reliable, not "insanely fast" ( the hardware should be fast, the software must be reliable )... and reliability means Referential Integrity, locks, and hot backups; hence, MyISAM tables should be scorched from the face of Earth, and we should never, ever, talk about them again... tongue

Rickard wrote:

PHP does not ask for the MySQL install path during compilation. Where did you get that from? In PHP4, the MySQL client library was bundled with PHP and therefore it made sense to enable the extension by default.

yes, you're right, of course... that's what i couldn't remember, there *is* a bundled mySQL into PHP4... sorry, got confused.

Rickard wrote:

In PHP5, it is no longer bundled and in order to use MySQL with PHP5, you have to explicitly tell configure that you want it (--with-mysql=/path/to/mysql).

hey, that GREAT news ( obviously i haven't been following PHP5 development )... if i don't want mysql on my server, why the scripting language should have that overhead ?!... hmmm... as soon as i find some spare time i might have some PHP5 testing to do...

Rickard wrote:

I guess this turned into a flame war after all. Oh well, a flame a day keeps the doctor away.

not at all, we haven't even called each other names, yet.... wink

oh, one more thing, ( just a matter of personal preference ) before i forget, i really hate software i can't just "./configure && gmake && gmake install"... mySQL install process used to be waaaay too different ( also is sapDB/maxDB/whatever ), i don't know how it is nowadays.

2

(6 replies, posted in Programming)

had to register so i could share a thought or two about this thread.
not trying to start a flame here, but IMHO, coming from an Oracle background, I find PostgreSQL superior to mySQL on every aspect ( the licensing to begin with; but also: http://sql-info.de/mysql/gotchas.html and  http://vulcanus.its.tudelft.nl/~acm/got/antimysql.php ), the "performance" could have been an issue in the past, but now it seems to perform as well as mySQL ( even better on higher loads, i've heard ).

I use PostgreSQL on professional webapplications, when the client won't afford an Oracle license ( no, i don't deal with MSSQL, or microsoft servers, only *NIX ); the only reason i see people insist on using mySQL is the tight integration with PHP ( at compiling, PHP asks for mySQL install path... wtf ?!? ) and the windows compatability, therefore, so many (cheap) hosts offer it.

with me, the first thing i do as soon as i get a new server ( VPS or dedicated ) is to compile/install PostgreSQL; no matter what i'm doing ( mod_perl, php or JAVA ) the DB backend is either PostgreSQL or Oracle.

( and a happy new year to all you and your families, folks ! )