RE: Improving insertion performance by locking tables

2003-07-14 Thread Rudy Metzger
;line too long". Cheers /rudy -Original Message- From: Phil Bitis [mailto:[EMAIL PROTECTED] Sent: maandag 14 juli 2003 11:44 To: [EMAIL PROTECTED] Subject: Re: Improving insertion performance by locking tables Is there a limit to the number of records I can insert in a multiple-value insert?

Re: Improving insertion performance by locking tables

2003-07-14 Thread Phil Bitis
Is there a limit to the number of records I can insert in a multiple-value insert? - Original Message - From: "Rudy Metzger" <[EMAIL PROTECTED]> To: "Phil Bitis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 10:18 AM Subject:

RE: Improving insertion performance by locking tables

2003-07-14 Thread Rudy Metzger
>From what I know is, that MySQL always locks the MyISAM table before you insert, update or delete something from it. So the key here is not so much if you should lock the table, but how you insert the data (single inserts vs multi inserts). Multi inserts are the way to go. By locking the table you