By cmejo on

Have currently 2000 pages of content on another CMS, going to move over to drupal. We are going to be adding pages every day. Search is extensively utilized. I plan on using faceted_search or apache solr as well to have advanced search features available.

I need to maximize performance. I have experience with MySQL but not much with PostgreSQL. I've heard PostgreSQL is faster in some situations. Is this one such situation? What do you recommend?

Thank you!

⋅ Categories: Drupal 6.x

Comments

nihonsei’s picture

nihonsei commented

MySQL: http://www.mysql.com/ (The world's most popular open source )
PostgreSQL : http://www.postgresql.org/ (The world's most advanced open source database)

I am using xampp (MySQL 5.1.41) for off-line my drupal website. So, I am using same database (MySQL) for a live website too.

Please ask to your host provider, which database connection speed is faster.
Use latest stable version of any one of above databases.

mradcliffe’s picture

mradcliffe
he/him
Primary language English
commented

I would probably stick with whatever database you're currently using to make migration easier.

That said, if you're currently on Oracle it's much easier to go to Postgresql.