>From past experiences I'll tell you that PostgreSQL is *dog slow*! We had a
search engine with about 10,000 entries in it that was being run on MySQL,
moved it to PostgreSQL and *bam*.. even with proper indexing & limiting
queries, it took 2-5 seconds to execute a simple query (server was load
free). So anyways.. don't waste your time installing PostgreSQL.
I've heard good things about Solid.. so maybe you start there.
Jeff Warner wrote:
> We were a mySQL shop. We replaced mySQL with Oracle8i/mod_perl and
> and Apache::DBI. Works great, once it is all setup. Our overall
> processing is faster with Oracle too. The lack of transactions and
> views put an immediate end of mySQL once we got into the details of my
> project.
>
> Oracle is overkill for smaller task but you don't have to worry about
> outgrowing it.
What about PostgreSQL (www.postgresql.org)? It looks like it has transaction
management (commit, rollback) with the whole concurrency control thing. I
don't know if has views. I've got a small project that I am figuring on
using PostgreSQL for, so I'm curious to hear what people might have to say
about it.
Another option to look at is Solid (www.solidtech.com). They just quoted me
their Solid Embedded Server (their name for a database server) for $2,000
per CPU. I used their database server a few years ago and it was very nice.
Back then it cost only $200, too... :-)
- David Harris
Principal Engineer, DRH Internet Services
