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?!
the SQLstatement looks like
"INSERT INTO `Counts` (`id`, `date`, `count`, `avg)VALUES ('', CURDATE(),
'$count', '$avg')"
or
"UPDATE `Counts` SET `count` = '$count', `avg` = '$avg' WHERE `id` = '$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: [EMAIL PROTECTED]
www.bvcapital.com
_________________________________________
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
