Bruce Momjian wrote: > > > The bottom line is that the marketing of PostgreSQL is not even close to > > that of MySQL. Thank god the code, community and support doesn't follow > > suit! > > I think MySQL got a big start by migrating mSQL users years ago and > having a compatibility module for mSQL. One great advantage of mySQL (and mSQL) ist the low connection-overhead. Especially in mSQL this was an explicit design-goal. In CGI-based WEB-environments it is very important that the time spent for connecting the database is as low as possible. Time wasted there cannot be autweight by fast SELECTS since many CGI do only very few SQL-statements. Using later WEB-techniques (as e.g. Servlets or Fast-CGI) this part becomes less important since an single DB-connection can be kept open across multiple WWW-requests. In applications where the connection is kept open for a long time the connection overhead becomes insignificant. Elmar
