On Sat, 2002-02-02 at 20:22, Egor Egorov wrote:
> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
Hi,
Would the REPLACE .. SELECT be faster if i use LOCK TABLES as it says in
the manual for the INSERT command ?
It's a REPLACE .. SELECT for thousands of rows.
Thanx,
--
Dia
On Monday 04 February 2002 14:02, Henry Hank wrote:
> >> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
>
> That suggests using LOAD DATA INFILE, but I would really like to avoid
> dumping a very large ISAM mysql table to a text file, just to load it back
> into another tabl
>> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid dumping
a very large ISAM mysql table to a text file, just to load it back into another
table (MYISAM).
I was looking for answers as to why isamchk w
