speeding up UPDATE and INSERT

Hi there,

I'm currently writing a Data Mining program in Perl, my problem is that =
the
writing to the database takes awful long.
Are there any ideas how to speed up the inserting and the updating, =
besides
using the bind operator?!=09

the SQLstatement looks like

"INSERT INTO `Counts` (`id`, `date`, `count`, `avg)VALUES ('', =
CURDATE(),
'$count', '$avg')"

or=20

"UPDATE `Counts` SET `count` =3D '$count', `avg` =3D '$avg' WHERE `id` =
=3D '$id'"

so if anybody has an idea how to get this done faster (dumping the data =
to a
csv file first and updating all at once, or something like this) I would
love to hear it.
thanks a lot in advance.

regards

Matthias


_________________________________________

Matthias Eireiner

email: matthias.eireiner@ieee.org

www.bvcapital.com
_________________________________________


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org