Hi,
I also do a similar thing with my data pre-processing
scripts. I use a multiple insert command with INSERT
DELAYED. It has improved the performance by heaps. The
format is
INSERT DELAYED INTO table VALUES (c11, c12, c13),
(c21, c22, c23);
The INSERT DELAYED will delay the updates so that
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 lo
