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
