speeding up UPDATE and INSERT
am 20.04.2004 22:23:53 von Matthias EireinerHi 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