Re: running optimize/analyze command

[Ananda Kumar]

Hi Alex,
How do i get a csv engine into mysql binaries. Also the file is not comma
seperate values files, the value is seperated by a different a different
value.

regards
anandkl


On 5/26/08, Alex Arul Lurthu <alexj@stripped> wrote:
>
> 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
>