Currently working on a large internal PHP/MySQL/Apache system. (get ready for some "help needed" questions soon).
Aagh! Use Postgres! In a month or three's time you'll thank me...
Probably a stupid question but...
What advantages are there to migrating across to PostgreSQL now ?
For the kind of site that we are developing there seem to be no real advantages that I can make out? (considering that the user base here is 45 and at most 20 would be on-line at any one point).
The other problem that i can forsee is that apparantly PostgreSQL has an 8k row limit which is not un-workable but would require more time and effort than MySQL for some of my data structures at the present time.
The set-up here is not going to be "hardcore" like a commercial site with huge hit stats per day. I would presume we'll be lucky to hit 10,000 page hits in an average working day.
I would appreciate any helpful feedback here as the only useful comparison i've found so far seems to be inconclusive to say the least !!
Yours, Martyn
We offer PgSQL and MySQL hosting and I can safely say that MySQL handles every thing beautifully, we have a forum site that has 20k+ page displays that relies souly on MySQL
They are both good, but we found MySQL to be reliable and fast
Regards Darren
-----Original Message----- From: alug-admin@stu.uea.ac.uk [mailto:alug-admin@stu.uea.ac.uk]On Behalf Of Martyn Ashworth Sent: 16 August 2001 16:26 To: 'Alexis Lee' Cc: ALUG Messages (E-mail) Subject: [Alug] PostgreSQL v MySQL ??
Currently working on a large internal PHP/MySQL/Apache system.
(get ready
for some "help needed" questions soon).
Aagh! Use Postgres! In a month or three's time you'll thank me...
Probably a stupid question but...
What advantages are there to migrating across to PostgreSQL now ?
For the kind of site that we are developing there seem to be no real advantages that I can make out? (considering that the user base here is 45 and at most 20 would be on-line at any one point).
The other problem that i can forsee is that apparantly PostgreSQL has an 8k row limit which is not un-workable but would require more time and effort than MySQL for some of my data structures at the present time.
The set-up here is not going to be "hardcore" like a commercial site with huge hit stats per day. I would presume we'll be lucky to hit 10,000 page hits in an average working day.
I would appreciate any helpful feedback here as the only useful comparison i've found so far seems to be inconclusive to say the least !!
Yours, Martyn
alug, the Anglian Linux User Group list Send list replies to alug@stu.uea.ac.uk http://www.anglian.lug.org.uk/
http://rabbit.stu.uea.ac.uk/cgi-bin/listinfo/alug See the website for instructions on digest or unsub!
-
D -
Martyn Ashworth