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

Re: speeding up UPDATE and INSERT

At 12:24 -0700 4/20/04, Matthias Eireiner wrote:
>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.


You might find some useful ideas here:

http://dev.mysql.com/doc/mysql/en/Insert_speed.html

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

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

Re: speeding up UPDATE and INSERT

At 12:24 -0700 4/20/04, Matthias Eireiner wrote:
>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.


You might find some useful ideas here:

http://dev.mysql.com/doc/mysql/en/Insert_speed.html

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

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