From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Decide between Postgresql and Mysql (help of |
Date: | 2006-03-30 22:53:08 |
Message-ID: | 60mzf7pmsr.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
smarlowe(at)g2switchworks(dot)com (Scott Marlowe) writes:
> And that, nowadays, is generally the state of web development. It's
> not the language you're using to write it in, it's how efficiently
> you're using your database.
Which properly puts my comments in their place :-).
More importantly, that seems like a valid statement which has a *wide*
scope of effects and side-effects. Including some that ought to put
PostgreSQL in a very good place, in that it provides some very good
ways of achieving high efficiency.
Neat performance thing du jour: Hibernate seems to be the "neat new
Java persistence thing."
I have been very unimpressed with some of the web frameworks I have
seen thus far in their interaction with databases.
We use RT (Request Tracker) for tracking tickets, and in its attempt
to be "database agnostic," it actually only achieves being
MySQL(tm)-specific, because they have an automated query generator
that is only good at one style of queries at a time. Coworkers have
suggested improved queries that are (on occasion) hundreds or
thousands of times faster than what it generates; those improvements
fall on deaf ears because they wouldn't work with all the databases.
(Well, more precisely, they wouldn't work with MySQL(tm).)
There's a home grown flavor of Java persistence mapping; it doesn't
seem as heinous as RT's, but it still doesn't make it overly
convenient to replace poor queries with more efficient ones.
Hibernate has a nifty thing in the form of "Named Queries." It'll
often use its own "HQL" to auto-generate SQL, but any time the DBAs
come up with something that's nicely tuned, it seems to be highly
recommended to generate a "Named Query" for that which allows a Nice
Query to be made part of the application without too much weeping and
gnashing of teeth on either DBA or developers' sides.
A framework that allows you to thereby "soup up" how efficiently you
use your database... Hmm... I wonder if that fits into anyone's
notable quote? :-).
--
(format nil "~S(at)~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/lisp.html
"When I was a boy of fourteen, my father was so ignorant I could
hardly stand to have the old man around. But when I got to be
twenty-one, I was astonished at how much the old man had learned in
seven years." -- Mark Twain
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Marzin | 2006-03-31 02:08:05 | Re: Decide between Postgresql and Mysql (help of |
Previous Message | Steinar H. Gunderson | 2006-03-30 22:36:38 | Re: Decide between Postgresql and Mysql (help of |