Re: MySQL vs SQLServer vs PostgresSQL
Dear Kevin - Kevin Pratt writes: "IMO - mysql is just a disaster you are inviting on yourself. Isn't there some line about everyone having an opinion... you should see the responses to some recent bug reports ... We have run load tests ourselves, and postgres performs much the same under heavy load as no load, whereas mysql quickly gets slow and then just starts erroring out past a certain point. This is a strange comment. Ignoring for the moment the relative advantages or disadvantages of MySQL and Postgres they seem to say that "heavy load" doesn't impact Postgres' performance. So if we pin the CPU by doing random disk reads it doesn't slow down database functionality? Come on, that's just silly. We have had ihtml/postgres/odbc pooling working well under huge loads during our tests, where mysql could not compete at all. Furthermore postgres has a far richer set of functionality mysql users can only dream about. The broader feature set of Postgres over MySQL doesn't get a lot of intelligent rebuttal. However this is the first time I've ever heard someone claim that Postgres is faster. Will you provide some more detail regarding your "huge loads" and "tests"? Yours (curious now) - Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs SQLServer vs PostgresSQL
"William Goedicke" [EMAIL PROTECTED] wrote: The broader feature set of Postgres over MySQL doesn't get a lot of intelligent rebuttal. True. Fortunately, many web projects don't need triggers, subselects, etc. (and PostgreSQL is IMHO a little more difficult to manage). In those cases speed is probably an important criteria and MySQL is arguably faster. However this is the first time I've ever heard someone claim that Postgres is faster. Last summer Tim Perdue posted an article on phpbuilder that compared Postgre and MySQL and included some testing. I don't recall any of the details of the testing, but I do recall that it showed MySQL was faster, but Postgre could handle more client connections. See http://www.phpbuilder.com/columns/tim2705.php3. I haven't seen a benchmark for speed that Postgre has won, but as Postgre gets faster and MySQL adds more functionality perhaps the debate over the better RDBMS will be more interesting. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs SQLServer vs PostgresSQL
I have heard mysql is the access for unix... i would like to hear about comparisons with Mysql SqlServer and PostgresSQL Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs SQLServer vs PostgresSQL
Dear Kevin - (I can't resist the obvious quip.) Kevin Pratt writes: I have heard mysql is the access for unix... Yes, like emacs is the notepad for unix. Yours (in gentle jest) - Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs SQLServer vs PostgresSQL
The reason I asked... quote from another mail list I am on... "IMO - mysql is just a disaster you are inviting on yourself. you should see the responses to some recent bug reports - "we broke it purposely because it made things faster..." I looked over the code for the client libraries when we were having problems with mysql recently - it would be far faster if they just cleaned some of that mess up and did it correctly. It is very intolerant of a loaded down system. We have run load tests ourselves, and postgres performs much the same under heavy load as no load, whereas mysql quickly gets slow and then just starts erroring out past a certain point. If you would run a commercial site with Access, then you'll love unix's answer to Access - Mysql. We have had ihtml/postgres/odbc pooling working well under huge loads during our tests, where mysql could not compete at all. Furthermore postgres has a far richer set of functionality mysql users can only dream about. They are both free so I guess I can't say postgres is better value for the money :) You have to install from the command line yes, but generally a fresh unix install will include postgres if you tick it off during initial install. Otherwise get an rpm version and it is only a few commands to install it. The docs for postgres are also excellent for an open source project." Kevin. - Original Message - From: "William Goedicke" [EMAIL PROTECTED] To: "Kevin Pratt" [EMAIL PROTECTED] Cc: "Mysql List" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 6:42 PM Subject: MySQL vs SQLServer vs PostgresSQL Dear Kevin - (I can't resist the obvious quip.) Kevin Pratt writes: I have heard mysql is the access for unix... Yes, like emacs is the notepad for unix. Yours (in gentle jest) -Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
