speeding up inserts



according to the mysql manual, multiple inserts can be sped up by
locking the table before doing them and unlocking the table afterwards.

is the same true of multiple inserts in mysql? if so, how would the
table be locked?

any insights would be appreciated - thanks!

.



Relevant Pages

  • Re: speeding up inserts
    ... locking the table before doing them and unlocking the table afterwards. ... is the same true of multiple inserts in mysql? ...
    (comp.databases.ms-sqlserver)
  • Re: How do I print from PowerPoint to a multipage image?
    ... I do not have larger paper so I want to print it in pieces on multiple ... sheets then tape them together afterwards. ... Steve Rindsberg, PPT MVP ...
    (microsoft.public.powerpoint)
  • Re: Access 07: My query is making the back end database lock up
    ... settings for record-level locking, optimistic locking, and other ... I can have multiple machines open their own front-end instance of ... Can you work between the two open apps? ...
    (comp.databases.ms-access)
  • Re: BerkeleyDB locking question
    ... >> The simplest form of locking available in Berkeley DB is called ... >> Concurrent Data Store CDS. ... It allows single writer, multiple readers. ... DB uses per-machine IPC for locking. ...
    (comp.lang.perl.misc)
  • Procmail: Why are these users getting multiple copies?
    ... Messages matching rule are delivered multiple times ... UserA is subscribed to a newsletter ("PATTERN" is always in the ... Can anyone explain why UserB and UserC get multiple copies? ... Without locking is exactly the same as with locking ... ...
    (comp.mail.misc)