[OSM-dev] Fwd: Re: Too many slow queries in db

Robert (Jamie) Munro rjmunro at arjam.net
Tue Sep 4 12:05:01 BST 2007


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

Brent Easton wrote:
>> Seriously, I think it is (a) get a proper database and (b) find somebody
>> with sufficient experience of designing hardware and software solutions
>> for massive database to make it work.
> 
> Has anyone tried approaching ORACLE for a sponshorship?

If at all possible, I'd prefer we steer clear of non-free databases, but
I'd prefer anything other than MySQL.

MySQL is often held up as a great thing by people who need a database
and had never seen one before. If you've never used a relational
database before, then, yes, MySQL is better than not using a relational
Database. Unfortunately, if you've used other relational databases,
MySQL is crap.

For example, it's taught open source people that you can't rely on
database referential integrity, you have to program that in your front
end (rails, for example).

It's taught people that sub-queries are a bad thing because they are
slower than doing a weird impossible to read join statement:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html

Other open source databases I know (Postgres and Firebird) aren't like that.

Robert (Jamie) Munro
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG3Tvbz+aYVHdncI0RAqteAKD71juCBCAR6lz+zC3IrNOtuSH/QQCg2Y+3
hq62WYAklyo3iVneKlRsoIw=
=mYnS
-----END PGP SIGNATURE-----




More information about the dev mailing list