Re: speeding up inserts

From: Robert Klemme <bob.news@xxxxxxx>
Date: Wed, 29 Mar 2006 19:24:18 +0200

zelnaga@xxxxxxxxx wrote:

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!

Um, this is a newsgroup dedicated to Microsoft SQL Server. You're probably better off checking in news:comp.databases.mysql .

Cheers

robert

.

Follow-Ups:
- Re: speeding up inserts
  - From: zelnaga

References:
- speeding up inserts
  - From: zelnaga

Prev by Date: Re: Optimizing SQL - Union
Next by Date: Hiding NULL
Previous by thread: speeding up inserts
Next by thread: Re: speeding up inserts
Index(es):
- Date
- Thread

Relevant Pages

speeding up inserts
... multiple inserts can be sped up by ... locking the table before doing them and unlocking the table afterwards. ...
(comp.databases.ms-sqlserver)
Multiple database deamons, single LVM backend?
... were using MySQL and were using multiple MySQL servers, ... own CPU + disk which replicate to each other. ...
(comp.databases)
Re: Multiple database deamons, single LVM backend?
... > were using MySQL and were using multiple MySQL servers, ... > wouldn't have replication problems. ...
(comp.databases)
Re: How best to use php5 objects between pages?
... useful between multiple pages on a site? ... You can use the HEAP storage engine in MySQL (I suppose you are using ... reading large session files or to storing data in MyIsam or InnoDB ...
(comp.lang.php)
Re: php/mysql multiple select list box(beginner).
... I have a task where I have to fetch datas from mysql and display it ... getting diplayed correctly in the multiple select box. ...
(comp.lang.php)