From: Shu-yu Guo <shu@...>
Date: 2004-04-21T06:38:06+09:00
Subject: Re: The quest for opensource database...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I love PostgreSQL as well, and my main gripe with it is speed. I often 
run into situations where classes correspond nicely to tables (like a 
User class to a users table), so I'm tempted to write code which would 
automatically query the database for the neccessary information in its 
initialize. However, this gets quite slow because it becomes hard to 
combine simple queries into complex ones (which execute much much 
faster). I have made optimizations around this, but they're not as nice 
to use as just pure data encapsulation.

This is in no way meant to discourage you from using PostgreSQL, merely 
inform you on its biggest limitation I see. It has too many other 
merits to be given up (triggers, decent transaction support, so on).

As a friend has told me again and again, always choose data integrity 
over speed.
- -- 
Lo-lee-ta: the tip of the tongue taking a trip of three
   steps down the palate to tap, at three, on the teeth.
Lo. Lee. Ta.               GUO Shu-yu <shu@rufuran.org>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFAhZg5TrIPVeT9UA0RAjmQAJ9Q6odYknQjW+JGNUxmHcDp1giu+QCfR/1t
6c2LHkvNtvGnzl0cVFZq11U=
=A0Uj
-----END PGP SIGNATURE-----