Re: Slow 'sending data' phase on mySQL query, for simple query

[Ventsislav Alexandriyski]

If cpu speed was proprtional to cpu clock, people still have to use p4 cpus
It is clear that few smaller tables will process faster than one gig table, but also when you have split table new tables are good ordered, white big old table is fragmented and this also impact performance. If you create copy of big table it will perform faster

-------------------------------Signature-----------------------------------------
http://www.nezavisim.com
I need job so if in your company there is need for optimizing and improving I am the man.
I can work from home via internet. Results are always best

I can complete all tasks from idea to final product, handling hardware desing, programming, installing and configuring all required hadrware and software.
And what can you?

Forum Moderators delete my posts so I cannot write delailed explanations, becaue this will be waste of time when my post is deleted by motherators