MySQL Forums :: Performance :: Attempt to split big table into smaller one made query slower


Advanced Search

Attempt to split big table into smaller one made query slower
Posted by: Patrick St.Onge ()
Date: March 11, 2010 09:59AM

I'm trying to increase the performance of my database by splitting a big table into smaller ones. the big table has data for many clients so I duplicated it and deleted all the data except for one client. This new table has 1 million rows instead of 20 million. I ran optimize table on it to get the size down. I was hoping this would speed up my query, but instead, it made it slower. How could a table with a lot less rows be slower? I tried deleting any irrelevant indexes and columns (like the clientID) but it made no difference.

Options: ReplyQuote


Subject Views Written By Posted
Attempt to split big table into smaller one made query slower 2989 Patrick St.Onge 03/11/2010 09:59AM
Re: Attempt to split big table into smaller one made query slower 1312 Rick James 03/12/2010 09:54PM
Re: Attempt to split big table into smaller one made query slower 1322 Ventsislav Alexandriyski 03/13/2010 02:48AM
Re: Attempt to split big table into smaller one made query slower 1364 Patrick St.Onge 03/15/2010 07:17AM
Re: Attempt to split big table into smaller one made query slower 1456 Rick James 03/15/2010 08:36AM
Re: Attempt to split big table into smaller one made query slower 1250 Patrick St.Onge 03/15/2010 09:40AM
Re: Attempt to split big table into smaller one made query slower 1388 Rick James 03/15/2010 07:35PM
Re: Attempt to split big table into smaller one made query slower 1213 Patrick St.Onge 03/19/2010 09:40AM
Re: Attempt to split big table into smaller one made query slower 2471 Rick James 03/20/2010 10:28AM
Re: Attempt to split big table into smaller one made query slower 1199 Patrick St.Onge 03/24/2010 02:26PM
Re: Attempt to split big table into smaller one made query slower 1384 Rick James 03/24/2010 09:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.