Re: Utilize maximum system resources for better performance

[Ronald Brown]

Rick James Wrote:
-------------------------------------------------------
> It copies the entire record over, regardless of
> how little is changed.

should i dot partitiona as you suggested or create a new table with values changing more often and then do left join ?

> > > Did you specify "ROW_FORMAT=FIXED"? If so,
> why?
> > nope i didnt specify it , i convrted this table
> from myisam to innodb
>
> Yeah, I don't know what, if anything, it means for
> InnoDB.

i guess i should leave it as it is then.

> > generating xml
>
> Perhaps much of the time is in this step?

i guess, coz generating sitemap takes around 6.x minutes for all records.

Thanks for your reply.
i missed you man, are you all right ?
Best Wishes.