Jeconais
November 25th, 2005, 05:38 PM
First off: I'm not trying to start a flame war here, honest :)
I've been using MySQL for several years both professionally and privately - however, my current host only comes with MySQL 3.23, and while I can upgrade it myself, I'd rather not (I like having people to shout at if anything goes wrong)
I do, however, have the option of moving to Postgre.
From a code perspective, switching is not going to be a major issue, I wrote the software with a DB abstraction layer by default, so I can stick a new file in place and the site will switch.
From an educational perspective, I'd quite like to switch, to see what the grass is like on the other side. And from a data quality (transactions) perspective it's attractive.
The small website I'm running is basically on around 500,000pi's a week, and at the moment, is lighting fast. Page generation time is in the sub 0.01s range.
So, to finally get to the point, I've got the general idea that "MySQL == Fast" "Postgre == Feature Packed". Is this still true, and if I switch, will I notice a slow down?
Second, are their any "gotchas" to look out for? Most of the queries I run are simple joins, and obviously I'll be doing a lot of testing before I put it on the server, but any advice would be welcome.
Cheers,
J
I've been using MySQL for several years both professionally and privately - however, my current host only comes with MySQL 3.23, and while I can upgrade it myself, I'd rather not (I like having people to shout at if anything goes wrong)
I do, however, have the option of moving to Postgre.
From a code perspective, switching is not going to be a major issue, I wrote the software with a DB abstraction layer by default, so I can stick a new file in place and the site will switch.
From an educational perspective, I'd quite like to switch, to see what the grass is like on the other side. And from a data quality (transactions) perspective it's attractive.
The small website I'm running is basically on around 500,000pi's a week, and at the moment, is lighting fast. Page generation time is in the sub 0.01s range.
So, to finally get to the point, I've got the general idea that "MySQL == Fast" "Postgre == Feature Packed". Is this still true, and if I switch, will I notice a slow down?
Second, are their any "gotchas" to look out for? Most of the queries I run are simple joins, and obviously I'll be doing a lot of testing before I put it on the server, but any advice would be welcome.
Cheers,
J