Re: [PHP] Performance question for table updating

2007-11-27 Thread Andrew Ballard
On Nov 24, 2007 2:32 AM, Jon Westcot <[EMAIL PROTECTED]> wrote: > Hi all: > > For those who've been following the saga, I'm working on an application > that needs to load > a data file consisting of approximately 29,000 to 35,000 records in it (and > not short ones, > either) into several tab

Re: [PHP] Performance question for table updating

2007-11-25 Thread Chris
Eventually, I wind up with a query similar to: UPDATE table_01 SET field_a = 'New value here', updated=CURDATE() WHERE primary_key=12345 Even though you've solved it one way to work out the problem here would be to change it to a select query (unfortunately mysql can't explain

Re: [PHP] Performance question for table updating (SOLVED)

2007-11-24 Thread Robert Cummings
On Sat, 2007-11-24 at 04:03 -0700, Jon Westcot wrote: > > Moral of the story? Two, really. First, ensure you always reference > values in the way most appropriate for their type. Second, don't make your > idiocy public by asking stupid questions on a public forum. What's the > quote (prob

RE: [PHP] Performance question for table updating (SOLVED)

2007-11-24 Thread Bastien Koert
Performance question for table updating (SOLVED) > > Hi Rob, et al.: > > - Original Message - > From: "Andrés Robinet" >>> -Original Message- >>> From: Jon Westcot [mailto:[EMAIL PROTECTED] >>> >>> :: gigantic snip here:: &

Re: [PHP] Performance question for table updating (SOLVED)

2007-11-24 Thread Jon Westcot
Hi Rob, et al.: - Original Message - From: "Andrés Robinet" <[EMAIL PROTECTED]> > > -Original Message- > > From: Jon Westcot [mailto:[EMAIL PROTECTED] > > > > :: gigantic snip here:: > > > > So, long story short (oops -- too late!), what's the concensus > > among the learned as

RE: [PHP] Performance question for table updating

2007-11-24 Thread Andrés Robinet
> -Original Message- > From: Jon Westcot [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 24, 2007 4:32 AM > To: PHP General > Subject: [PHP] Performance question for table updating > > Hi all: > > For those who've been following the saga, I'm working on an > application that need