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!