RE: [CFTALKTor] Arrrggghhh! Painfully slow

[Byron Bignell]

MySQL is a reasonable datatabase, if you don't use views, stored proceedures, transactions, triggers...get the picture...

 

PostgreSQL is ANSI compliant.  It's free as well, but it's a real database.  IMHO MySQL is little better than Access or DBase.

 

We've tested both and have found PostgreSQL to be a perfect replacement for Sybase and MS-SQL7/2000.  There's even a nice Win32 client for it.  You can, with very little effort, run your SQL scripts under PostgreSQL and be up and running in no time at all.

 

WQe even run it as a service on Wonkos 2000 using CYGWIN.  Simple to set up, robust and best of all an industrial strength database, not a toy.

 

(boy, I can hear the flame guns warming up already...people get really attached to their databases...I think it's illegal to get too personal with them though...)

 

Byron

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michel Rouse
Sent: Tuesday, May 28, 2002 4:23 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] Arrrggghhh! Painfully slow

MySQL was highly recommended.  Are there issues with MySQL?  Would postgress be better?

 

Hmmmm...  I wonder if I can convince my IS department to re-install the entire machine?

 

I'm sure it would cost me a small fortune in beer :-)

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Byron Bignell
Sent: Tuesday, May 28, 2002 4:10 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] Arrrggghhh! Painfully slow

....kill it...

 

...win...

 

Actually, I have no idea what it could be...but burning the machine to the ground and re-building is my response to these issues...

 

...why mysql?  why not postgresql? 

 

Byron

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michel Rouse
Sent: Tuesday, May 28, 2002 4:09 PM
To: Toronto CFUG (E-mail)
Subject: [CFTALKTor] Arrrggghhh! Painfully slow

I am having a performance issue with my production machine. It seems to be painfully slow. Somage pages take 10 - 20 seconds to process (compared to .3 seconds on the development machine). The load on the server is light and it has alomost 600MB RAM. It is a PII 450 CPU running RedHat Linux 6.2. The only differences between the development server and the production server is that the MySQL server (installed on the same machine for development, installed on a seperate machine for production). Even pages that do not touch the DB are slow to load. If I reboot the machine, it will run quick for about 45 minutes, then start to slow down.

Anyone have any ideas?

Michel

"Put your hand on a hot stove for a minute, and it seems like

an hour. Sit with a pretty girl for an hour, and it seems like

a minute. That's relativity."

-- Einstein, Albert

_______________________

Michel Anthony Rouse

Webmaster

Steltor

2000 Peel street, 4th floor

Montreal, Quebec

H3A 2W5

Canada

tel: +1 (514) 733-8500 x-5001

fax: +1 (514) 733-8878

[EMAIL PROTECTED]

www.steltor.com

Toll free in North America: 1-800-675-2991