Re: [HACKERS] RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-21 Thread Thomas Lockhart
I've wondered and am still wondering what a lot of these benchmark tests are out to prove. In this case, the "benchmark test" was not out to prove anything. It was an good-faith result of a porting effort with a suprising (to the tester) result. I'm not sure that any PostgreSQL advocate

[HACKERS] RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-20 Thread fabrizio . ermini
Still...Regardless of what database they're running, either their abstraction layer is shit or their queries really need optimized. Is that perhaps why, even at 5 clients, the page views he shows never went significantly above 10/sec? I think this could be because they used real killer

Re: [HACKERS] RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-20 Thread Mitch Vincent
uot; [EMAIL PROTECTED]; [EMAIL PROTECTED]; "Michael Fork" [EMAIL PROTECTED]; "Poul L.Christiansen" [EMAIL PROTECTED] Cc: "pgsql-general" [EMAIL PROTECTED]; "pgsql-hackers" [EMAIL PROTECTED] Sent: Monday, November 20, 2000 8:48 PM Subject: Re: [HACKERS] RE: [GENERAL]

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-20 Thread Don Baccus
At 09:43 AM 11/13/00 -0600, [EMAIL PROTECTED] wrote: I made it all the way through the article. I'll summarize it for you: Postgres - hooray! MySQL - boo! Since this is an open source database article linked off of slashdot, I imagine they're getting pounded. Why is all this e-mail showing up

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread Don Baccus
At 01:53 PM 11/15/00 -0500, markw wrote: I'd rather not pollute the application's SQL with postgres-isms. Not that I don't love postgres, but there are always critics looking for a reason to use Oracle or (gasp) MS-SQL. Define some global variable with the name of the database being run

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread Tom Samplonius
On Wed, 15 Nov 2000, carl garland wrote: perhaps why, even at 5 clients, the page views he shows never went significantly above 10/sec? I think alot of it has to do with the web server/db setup not pg. They are using Apache/PHP and looking at their code every page has the additional

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread joseph
On Wed, 15 Nov 2000, carl garland wrote: # perhaps why, even at 5 clients, the page views he shows never went # significantly above 10/sec? # # I think alot of it has to do with the web server/db setup not pg. They are # using Apache/PHP and looking at their code every page has the

Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread Martin A. Marques
On Lun 13 Nov 2000 13:22, Robert D. Nelson wrote: Still...Regardless of what database they're running, either their abstraction layer is shit or their queries really need optimized. Is that perhaps why, even at 5 clients, the page views he shows never went significantly above 10/sec? In the

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread Tom Lane
markw [EMAIL PROTECTED] writes: Just a question, however, what is the feeling about the way statistics are currently being calculated? They suck, no question about it ;-) My feeling is that some sort of windowing algorithm be used to normalize the statistics to the majority of the entries

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread carl garland
perhaps why, even at 5 clients, the page views he shows never went significantly above 10/sec? I think alot of it has to do with the web server/db setup not pg. They are using Apache/PHP and looking at their code every page has the additional overhead of making the db connection. Now if

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread Don Baccus
At 09:27 AM 11/15/00 -0800, Tom Samplonius wrote: AOLServer isn't the only system that can pool database connections, so can servlets/JSP, ColdFusion, ASP, etc. No doubt AOLServer would be more widely accepted if it used something other than TCL. There are two separate modules that support

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread markw
Andrew McMillan wrote: mlw wrote: My music database has 50,000 arises and 210,000 albums. Many artists have only one or 2 entries in the albums table (for the youngsters, CD table ;-). About 34,000 have the integer key for "Various Artists" as their artist entry, and another few

RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-13 Thread Robert D. Nelson
And now it's on www.slashdot.org ... http://slashdot.org/articles/00/11/13/1342208.shtml Poul L. Christiansen Michael Fork wrote: Thought this may be of interest to some... http://www.phpbuilder.com/columns/tim20001112.php3 Michael Fork - CCNA - MCP - A+ Network Support - Toledo

[HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-13 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] And now it's on www.slashdot.org ... http://slashdot.org/articles/00/11/13/1342208.shtml Poul L. Christiansen Michael Fork wrote: Thought this may be of interest to some... http://www.phpbuilder.com/columns/tim20001112.php3

[HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-13 Thread Poul L. Christiansen
And now it's on www.slashdot.org ... http://slashdot.org/articles/00/11/13/1342208.shtml Poul L. Christiansen Michael Fork wrote: Thought this may be of interest to some... http://www.phpbuilder.com/columns/tim20001112.php3 Michael Fork - CCNA - MCP - A+ Network Support - Toledo

RE: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-13 Thread Robert D. Nelson
I made it all the way through the article. I'll summarize it for you: Postgres - hooray! MySQL - boo! Yeah, and that's about it. No analysis or anything. Disappointing, after waiting so long for the pages to load. Since this is an open source database article linked off of slashdot, I imagine