MySQL Forums
Forum List  »  InnoDB

Re: partitioning of a table
Posted by: Rick James
Date: June 02, 2014 09:41PM

> SELECT tbldebart.* FROM tbldebart;

This reads the entire table, hence it takes as long as it takes the disk to transfer all the data. It will take that long whether it is PARITIONed or not.

I'm not familiar with the rest of the code -- is it creating some SQL? If so, please show us the SQL that is built by it.

Options: ReplyQuote


Subject
Views
Written By
Posted
1882
May 01, 2014 05:25AM
942
May 02, 2014 10:51AM
997
May 05, 2014 07:31AM
929
May 05, 2014 07:54AM
978
May 06, 2014 06:02PM
810
May 07, 2014 03:20AM
850
May 08, 2014 08:50AM
969
June 02, 2014 02:09AM
Re: partitioning of a table
916
June 02, 2014 09:41PM


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.