Hi Etienne, also you may clean up your transaction log . This also may help.
Brian
----- Original Message -----
From: "Ulrich Borchers" <borchers@stripped>
To: <perl@stripped>; "Etienne Orliac" <isxejo@stripped>
Sent: Thursday, April 01, 2004 2:52 PM
Subject: Re: How to speed UPDATES
Hi Etienne,
can you please post the query and the table structure (create table,
indexes).
Maybe you can tweak this by creating indexes on the right
columns if you have not already done so. Even dropping an
index might help. I doubt that 1500 update queries take
so long even on large tables if you have the right indexes
created and data types selected.
Uli
On 1 Apr 2004 at 20:32, Etienne Orliac wrote:
> Dear all,
>
> I have to update 1500 lines on a daily basis in a single table. My
problem is that it takes a while to execute. All the updates are siimilar.
>
> I've read that you can delay the updates and just execute once or
something like that. However, I wasn't able to find any documentation about
it.
>
> So I would greatly appreciate some help.
>
> Thanks a lot,
>
> Etienne.
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=1
>
--
Ulrich Borchers
Brandenberger Str.18
41065 Mönchengladbach
Tel. (0 21 61) 17 58 83
Mobil (0 179) 72 66 112
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=1
