This may seem like a naive question, but I'm a little lost.
I've been scanning the archives and benchmarks and all kinds of things for
DAYS now, trying to work out whether to go with postGres or mySQL as the
database backend for my own personal website, which is a writers site. The
site is growing well, but it's not database intensive, it doesn't require
millions of inserts or 100000 record selects every five seconds. Users
submit text data which gets inserted, make minor updates, and then search
and list using select queries.
Everything I'm seeing in all the speed comparisons etc etc seems to be
focused toward people looking for huge, mission critical speed reliant down
to the millisecond databases. I simply have a couple of functional
quandaries - myaql doesn't implement foreign key constraints well, but in
the benchmarks postgresql seems slower - what I want to know is for the kind
of functionality I'm going to be using, is the "speed" difference between
mysql and postgresql even going to be noticably at that level? Or is it
something that should factor heavily in my decision?
Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN 13107913
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
