Re: [ADMIN] v7.1b4 bad performance

2001-02-14 Thread Karel Zak
On Wed, 14 Feb 2001, Tom Lane wrote: > "Schmidt, Peter" <[EMAIL PROTECTED]> writes: > > However, what I'm interested in is the comparison between 7.0x and 7.1x. > > Shouldn't the 7.1b4 database be faster? Have you (or anyone else) done this > > comparison? > > 7.1 is considerably faster if you

Re: [ADMIN] v7.1b4 bad performance

2001-02-14 Thread Tom Lane
"Schmidt, Peter" <[EMAIL PROTECTED]> writes: > However, what I'm interested in is the comparison between 7.0x and 7.1x. > Shouldn't the 7.1b4 database be faster? Have you (or anyone else) done this > comparison? 7.1 is considerably faster if you compare performance without -F. If you are comparin

RE: [ADMIN] v7.1b4 bad performance

2001-02-14 Thread Michael Ansley
Title: RE: [ADMIN] v7.1b4 bad performance How closely matched are the parameters of your 7.0 and 7.1 servers? Particularly the -B parameters.  Anyway, I'm busy trying to get my server set up with both version to run the tests.  I'll get back to you...    -Original Message-From: Schmi

RE: [ADMIN] perfomance question

2001-02-14 Thread Michael Ansley
Title: RE: [ADMIN] perfomance question You might try pooling your database connections, for a start.  You don't say anywhere that you are doing this. Cheers... MikeA -Original Message- From: Nikolay Mijaylov [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 10:23 To: [EMAIL PR

[ADMIN] perfomance question

2001-02-14 Thread Nikolay Mijaylov
Hi all, I have a large site currently hosted at following machine: Linux 2 64MB RAM, 2x100 MB Swap Apache 1.3.X ( 120 connections, 2 min ) PHP 3.0.18 installed as CGI binary MySQL ( 150 connections) sitename: http://picof.com/nmmm The site have too many visitors and all the pages are

RE: [ADMIN] v7.1b4 bad performance

2001-02-14 Thread Schmidt, Peter
Title: RE: [ADMIN] v7.1b4 bad performance I'm using a test machine that is even less powerful than what you are using. However, what I'm interested in is the comparison between 7.0x and 7.1x. Shouldn't the 7.1b4 database be faster? Have you (or anyone else) done this comparison? Also, I'm no