----- Original Message ----- From: "Johan Wahlström" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 29, 2001 2:39 AM Subject: Re: Most Performance, Opinions ?
> Hello! > > Can I actually turn off locks all the way, so that updates never locks > a MyISAM table at all ? > > regarding mysql_pconnect() we haven't tried that, but the nature of > the site suggests it would need like 500 apache deamons connected > all the time. And that's a lot of sort buffers and stuff beeing allocated > for each one of those ? > > regards, Johan > > > > ----- Original Message ----- > From: "Steve Rapaport" <[EMAIL PROTECTED]> > To: "Johan Wahlström" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Saturday, December 29, 2001 2:16 AM > Subject: Re: Most Performance, Opinions ? > > > > Hi. > > > > My question is similar to yours in some ways, > > perhaps we can help each other. > > > > You say > > > We need no transactions, or any data integrity at all. We can afford to > > > loose some data in trade for performance. (like a few hours or > something, > > > which seems like a lot even if the replication whould fail). > > > > If that's the case, why are you doing table locks at all? > > In most cases they won't be needed, and in the few cases where > > data might be overwritten, you can sacrifice that data for performance, > no? > > > > Also why are you reconnecting? I think you can use mysql_pconnect() > > to create a connection pool and save the connection overhead. > > > > > > > > -- > > Steve Rapaport > > World Citizen > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
