Re: running optimize/analyze command

[Alex Arul Lurthu]

On Mon, May 26, 2008 at 2:40 PM, chandru <pradeep.chandru@stripped>
wrote:

> Hi anand,
>  To add to alex's views, I see that you do two major operations
> 1. Insert
>
>   * Use a temporary table that loads the data initially and then you
>     copy the same to the original table, which can prevent load on the
>     original table and shall be faster as well.
>

Its a good point that Chandru is making here. One more optimization to go
with this is the following :

If you have  csv engine compiled into your binaries, then the temporary
table can created just by preparing the file with comma separated values and
moving the file to data directory and then start the load from there.


-- 
Thanks
Alex
http://alexlurthu.wordpress.com