UPDATE statement optimization

2005-10-10 Thread Jeffrey Santos
Hey all! I'm a very novice MYSQL user of the mentality of get it working, then get it working the right way, feeling the best way to learn is to just do it. I got things working but now I'm looking back and trying to get better efficiency out of my SQL statements. Database is setup like

Re: UPDATE statement optimization

2005-10-10 Thread SGreen
Jeffrey Santos [EMAIL PROTECTED] wrote on 10/10/2005 01:07:03 PM: Hey all! I'm a very novice MYSQL user of the mentality of get it working, then get it working the right way, feeling the best way to learn is to just do it. I got things working but now I'm looking back and trying to

RE: UPDATE statement optimization

2005-10-10 Thread Jeffrey Santos
PM To: Jeffrey Santos Cc: mysql@lists.mysql.com Subject: Re: UPDATE statement optimization Jeffrey Santos [EMAIL PROTECTED] wrote on 10/10/2005 01:07:03 PM: Hey all! I'm a very novice MYSQL user of the mentality of get it working, then get it working the right way, feeling the best

RE: UPDATE statement optimization

2005-10-10 Thread SGreen
Subject: Re: UPDATE statement optimization Jeffrey Santos [EMAIL PROTECTED] wrote on 10/10/2005 01:07:03 PM: Hey all! I'm a very novice MYSQL user of the mentality of get it working, then get it working the right way, feeling the best way to learn is to just do it. I

RE: UPDATE statement optimization

2005-10-10 Thread Jeffrey Santos
PM To: Jeffrey Santos Cc: mysql@lists.mysql.com Subject: RE: UPDATE statement optimization Unless you are on a severely underpowered machine, MySQL will handle 3 million rows without any problems. If you are on such an underpowered machine, then your current process must absolutely CRAWL