Re: Design for a massive table (partitioning or sharding)
Posted by: Rick James
Date: August 25, 2015 12:18PM

Maybe.

It would be better to spell out
SHOW CREATE TABLE
and provide the main SELECTs.

PARTITIONing does not automatically provide _any_ performance benefits.

Sharding works best if you don't need to hit more than one shard for a given query. And sharding is not likely to help the 1-minute query run any faster; instead sharding is for scaling of reads.

Still, you may have a special case where PARTITIONing and/or sharding will help -- let's see the table and selects.

Options: ReplyQuote


Subject
Written By
Posted
Re: Design for a massive table (partitioning or sharding)
August 25, 2015 12: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.