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
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
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
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::
&
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
> -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
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 tables. I'm using
MySQL as the database.
I've noticed a really horrible p
7 matches
Mail list logo