Re: Database Performance?
От | Jean-Michel POURE |
---|---|
Тема | Re: Database Performance? |
Дата | |
Msg-id | 200202180941.g1I9exFP005605@www1.translationforge обсуждение исходный текст |
Ответ на | Re: Database Performance? (Andrew Sullivan <andrew@libertyrms.info>) |
Ответы |
Re: Database Performance?
Re: Database Performance? |
Список | pgsql-general |
Le Lundi 18 Février 2002 06:18, Andrew Sullivan a écrit : > I'd like to see some real benchmarks under load comparing PostgreSQL > and MySQL+InnoDB. It seems that such would be an apples::apples (ok, > maybe one's an overbred hybrid apple, but still an apple) comparison > at last. Anyone know how to do as much? Dear Andrew, The main difference is that PostgreSQL allows server-side programming and does things smartly: PostgreSQL supports triggers, rules, views, functions and types to deliver ready to use data to your backend (Apache, Java, Windows). PostgreSQL has several server-side languages (PLpgSQL, PLperl, PLbash, etc...) and may soon support Java server-side programming. It allows the storage of multi-byte data, including Unicode support. Optimization is 10% hardware, 90% software programming. The way you build tables, views and program server-side logic can boost your application by a factor of 10. As a result, an optimized database with PostgreSQL running on a i586 with IDE discs may handle more transactions than a double Pentium MySQL with Ultra-wide SCSI. This is life ! This is not a question hardware benchmark. Your email clearly shows that MySQL lacks features. Pease keep in mind that MySQL is developped by a single man (who accepts patches from others), not a community of developpers like PostgreSQL. But a tool is only worth "what you are doing with it". If you are a part-time hacker, MySQL may suffice for simple SELECT or UPDATE queries. IMHO, MySQL can only be used in an Apache environment with PERL/PHP. Also, do not use it in an ODBC environment, it is simply too buggy. This is personal experience. On the converse, if you are looking for a professional tool, go for PostgreSQL. Probably, the best way to start is http://pgadmin.postgresql.org and install pgAdmin2, PostgreSQL Windows GUI. pgAdmin2 makes programming very easy. Modern computing is "do it yourself and make your own mind". In a production environment, you will see it is not like apple:apple. Cheers, Jean-Michel POURE
В списке pgsql-general по дате отправления: