Re: [GENERAL] Database performance comparison paper.

2007-02-20 Thread Guido Neitzer
Am 19.02.2007 um 17:49 schrieb Jan Wieck: Oh, this one wasn't about raw speed of trivial single table statements like all the others? No, it wasn't. They also tested the insert performance of a system without foreign keys and without transactions (MySQL MyISAM) against systems with

Re: [GENERAL] Database performance comparison paper.

2007-02-20 Thread Andrej Ricnik-Bay
On 2/21/07, Guido Neitzer wrote: It would be more or less the same, if you compare copy against insert performance on PostgreSQL and state that insert should be as fast as copy without saying why. Btw: these guys claim to be database consultants. Guess one should consider oneself lucky not to

Re: [GENERAL] Database performance comparison paper.

2007-02-20 Thread Jan Wieck
On 2/20/2007 3:51 PM, Andrej Ricnik-Bay wrote: On 2/21/07, Guido Neitzer wrote: It would be more or less the same, if you compare copy against insert performance on PostgreSQL and state that insert should be as fast as copy without saying why. Btw: these guys claim to be database consultants.

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Andrew Sullivan
On Sat, Feb 17, 2007 at 12:02:08AM +0100, Leif B. Kristensen wrote: There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. There is, but it's not the sort of word one uses in polite company ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Geoffrey
Tom Allison wrote: Leif B. Kristensen wrote: On Friday 16. February 2007 07:10, Tom Lane wrote: Perhaps this paper can be described as comparing an F-15 to a 747 on the basis of required runway length. There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. The

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Jan Wieck
On 2/16/2007 1:10 AM, Tom Lane wrote: extra points, use *only one* test case. Perhaps this paper can be described as comparing an F-15 to a 747 on the basis of required runway length. Oh, this one wasn't about raw speed of trivial single table statements like all the others? Jan --

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Alexander Elgert
Marc Evans schrieb: Some people may find this interesting reading. http://us.devloop.org.uk/ Nice, but it would be interesting which storage engine was used for mysql - ok, default is MyIsam. Does mysql (in the latest version) still use a single write-thread for writing? In mysql 3, a

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Alexander Elgert
Richard Huxton schrieb: Shelby Cain wrote: Excerpt from the document: === 2. What is compared here - Apples and Oranges The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity. No

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Guido Neitzer
Am 15.02.2007 um 13:05 schrieb Alexander Elgert: Nice, but it would be interesting which storage engine was used for mysql - ok, default is MyIsam. They used MyISAM as it is described late in the paper. cug ---(end of broadcast)--- TIP 4:

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Tom Allison
Leif B. Kristensen wrote: On Friday 16. February 2007 07:10, Tom Lane wrote: Perhaps this paper can be described as comparing an F-15 to a 747 on the basis of required runway length. There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. The Internet is full of

Re: [GENERAL] Database performance comparison paper.

2007-02-16 Thread Tom Lane
Ron Johnson [EMAIL PROTECTED] writes: -BEGIN PGP SIGNED MESSAGE- Am 15.02.2007 um 11:21 schrieb Marc Evans: These *peeep* [deleted] compared MySQL with MyISAM to ACID compliant databases. So why not compare an F-15 to 747? What? Apples and Oranges? Bad analogy. Both the F-15 and

Re: [GENERAL] Database performance comparison paper.

2007-02-16 Thread Leif B. Kristensen
On Friday 16. February 2007 07:10, Tom Lane wrote: Perhaps this paper can be described as comparing an F-15 to a 747 on the basis of required runway length. There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. The Internet is full of it. -- Leif Biberg

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Shelby Cain
Excerpt from the document: === 2. What is compared here - Apples and Oranges The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity. No optimization, no tweaks, no editing of

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Alan Hodgson
On Thursday 15 February 2007 11:29, Shelby Cain [EMAIL PROTECTED] wrote: === 2. What is compared here - Apples and Oranges The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity. No

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Richard Huxton
Shelby Cain wrote: Excerpt from the document: === 2. What is compared here - Apples and Oranges The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity. No optimization, no tweaks, no

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Bill Moran
In response to Shelby Cain [EMAIL PROTECTED]: Excerpt from the document: === 2. What is compared here - Apples and Oranges The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity.

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Guido Neitzer
Am 15.02.2007 um 11:21 schrieb Marc Evans: http://us.devloop.org.uk/ These *peeep* [deleted] compared MySQL with MyISAM to ACID compliant databases. So why not compare an F-15 to 747? What? Apples and Oranges? So what? You can compare anything you want, right? Only the result

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/15/07 15:29, Guido Neitzer wrote: Am 15.02.2007 um 11:21 schrieb Marc Evans: http://us.devloop.org.uk/ These *peeep* [deleted] compared MySQL with MyISAM to ACID compliant databases. So why not compare an F-15 to 747? What?