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?! the SQLstatement looks like INSERT INTO `Counts` (`id`,

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

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?! the SQLstatement looks like INSERT INTO `Counts` (`id`,

Re: speeding up UPDATE and INSERT

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