RE: Gripe with MySQL

2004-04-21 Thread Jochem van Dieten
Peter J Milanese said: > > The lack of error checking on the server side means better > performance in my opinion. Does it? Or does client side error checking use server resources as well? Lets suppose that we want to validate a new message that is entered into a thread on a messageboard. Then we

Re: Gripe with MySQL

2004-04-20 Thread Peter Brawley
e <[EMAIL PROTECTED]> 04/20/2004 01:20 PM To: <[EMAIL PROTECTED]>, Donny Simonton <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]>, 'Stormblade' <[EMAIL PROTECTED]> Subject:RE: Gripe with MySQL

RE: Gripe with MySQL

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 15:33:18 -0400, Peter J Milanese wrote: > Just something I noticed missing here > > > The lack of error checking on the server side means better > performance in my opinion. No doubt. > When you're throwing > a couple thousand hits per second at it, this is visible. I woul

RE: Gripe with MySQL

2004-04-20 Thread David Brodbeck
> -Original Message- > From: Michael McTernan [mailto:[EMAIL PROTECTED] > > if you don't have error checking in yourself, that's your problem > > not mysql's problem. > > True, but still doesn't help when someone inexperienced with > MySQL makes a > mistake and buggers the database...

RE: Gripe with MySQL

2004-04-20 Thread Peter J Milanese
To: <[EMAIL PROTECTED]>, Donny Simonton <[EMAIL PROTECTED]> cc: <[EMAIL PROTECTED]>, 'Stormblade' <[EMAIL PROTECTED]> Subject:RE: Gripe with MySQL On Tue, 20 Apr 2004 17:57:08 +0100, Michael McTernan wrote: > Donny,

RE: Gripe with MySQL

2004-04-20 Thread Stormblade
--- Original Message --- From: "Stormblade" <[EMAIL PROTECTED]> To: Donny Simonton <[EMAIL PROTECTED]> Cc: Sent: Tue, 20 Apr 2004 12:59:58 -0400 Subject: RE: Gripe with MySQL > On Tue, 20 Apr 2004 11:37:12 -0500, Donny Simonton wrote: > Everybody should remembe

RE: Gripe with MySQL

2004-04-20 Thread Stormblade
not just one global error checking type. > > Thanks, > > > Mike > > >> -Original Message- >> From: Donny Simonton [mailto:[EMAIL PROTECTED] >> Sent: 20 April 2004 17:37 >> To: 'Michael McTernan'; 'Stormblade' >> Cc: [EMAIL PROTECTE

RE: Gripe with MySQL

2004-04-20 Thread Michael McTernan
database... again. I don't see why you object to making things easier to use, even if it is only activated by a -n00b option in mysql_safe. Thanks, Mike > -Original Message- > From: Donny Simonton [mailto:[EMAIL PROTECTED] > Sent: 20 April 2004 17:37 > To: 'Mi

Re: Gripe with MySQL

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 09:25:58 -0500, Peter Brawley wrote: >>If you are going to have a database that will be centralized for the > company >>and will have many different clients accessing it, I would tell them not to > use >>MySQL. > > OK, though 5.0 makes it possible to write stored procs that pr

RE: Gripe with MySQL

2004-04-20 Thread Donny Simonton
OTECTED] > Sent: Tuesday, April 20, 2004 9:04 AM > To: Stormblade > Cc: [EMAIL PROTECTED] > Subject: RE: Gripe with MySQL > > Hi, > > ENUM columns can also trip you up if you insert a value outside of the > ENUM; > an empty string is inserted instead. This is docu

Re: Gripe with MySQL

2004-04-20 Thread Peter Brawley
keep database-protecting validation where it belongs--on the server. PB - Original Message - From: Stormblade To: [EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 8:35 AM Subject: Re: Gripe with MySQL On Tue, 20 Apr 2004 09:48:11 +0200 (CEST), Jochem van Dieten wrote: > Stormbl

RE: Gripe with MySQL

2004-04-20 Thread Michael McTernan
Mike > -Original Message- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Stormblade > Sent: 20 April 2004 01:42 > To: [EMAIL PROTECTED] > Subject: Gripe with MySQL > > > Ok. Love MySQL and I will be using it for my personal use and recommending > it to clients as a lower

Re: Gripe with MySQL

2004-04-20 Thread Stormblade
On Tue, 20 Apr 2004 09:48:11 +0200 (CEST), Jochem van Dieten wrote: > Stormblade said: >> Ok. Love MySQL and I will be using it for my personal use and >> recommending it to clients as a lower cost alternative. I've only >> been using it for a very short time but there one major gripe I have >> wi

Re: Gripe with MySQL

2004-04-20 Thread Jochem van Dieten
Stormblade said: > Ok. Love MySQL and I will be using it for my personal use and > recommending it to clients as a lower cost alternative. I've only > been using it for a very short time but there one major gripe I have > with it and I believe it's just a design thing. > > MySQL seems to put the bu

Re: Gripe with MySQL

2004-04-19 Thread Stormblade
On Mon, 19 Apr 2004 20:17:38 -0700 (PDT), Marc Slemko wrote: > On Mon, 19 Apr 2004, Stormblade wrote: > >> Ok. Love MySQL and I will be using it for my personal use and recommending >> it to clients as a lower cost alternative. I've only been using it for a >> very short time but there one major

Re: Gripe with MySQL

2004-04-19 Thread Marc Slemko
On Mon, 19 Apr 2004, Stormblade wrote: > Ok. Love MySQL and I will be using it for my personal use and recommending > it to clients as a lower cost alternative. I've only been using it for a > very short time but there one major gripe I have with it and I believe it's > just a design thing. > > My

Gripe with MySQL

2004-04-19 Thread Stormblade
Ok. Love MySQL and I will be using it for my personal use and recommending it to clients as a lower cost alternative. I've only been using it for a very short time but there one major gripe I have with it and I believe it's just a design thing. MySQL seems to put the burden of error checking and s