Re: [mv] MySQL vs PostgreSQL

[cfm@maine.com]

******    message to minivend-users from cfm@maine.com     ******

On Tue, Jul 11, 2000 at 11:35:59PM -0700, Brian Wright wrote:
> ******    message to minivend-users from Brian Wright <bdw@aturna.com>     ******
> 
> 
> On 12-Jul-2000 Viktors Rotanovs wrote:
> > ******    message to minivend-users from Viktors Rotanovs <viktors@riga.nu>  
> > ******
> > 
> > Hi Brian,
> > 
> > PostgreSQL is much better, because it has referential integrity,
> > which is essential in e-commerce. That means, there will be
> > no products that do not belong to some category, no orders
> > belonging to non-existent users, etc.
> 
> That's why I was leaning towards PostgreSQL, because it supports the
> referential integrity.
> 
> > 
> > It is 2-3 times slower than MySQL, but is closer to SQL92,
> > so you will not have to re-learn SQL to use it.
> 
> Hehehe, I'm quite willing to sacrifice performance for the referential
> integrity.

That makes sense.  Still, my experience indicates that more you can offload 
from front end and the faster it goes the better results you get for the 
client and his customer.  The difference between .2 and .6ms may be 
irrelevant but on more complex queries it might be meaningful.  If you 
get to sites of a size where data integrity is an issue, then you will 
already be running several layers, backend db preprocessing for front 
end or some such.  Whatever is loading your commerce database should 
insure integrity and you should not have to worry about it real time 
run time.  Blue sky guess, I'd bet Google and Yahoo don't care about
referential integrity at the user interface but care a lot about it a
couple of layers back.

--

Has anyone here got any war stories about db2?  Frankly, we **are** looking
for that second layer back end.  ;^)

cfm

-- 

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list