MySQL Forums
Forum List  »  Partitioning

Re: Index causing much slower query
Posted by: Scott Noyes
Date: October 08, 2008 07:46AM

> Perhaps the index with (intcol, datetimecol) is too big to fit in memory while the other index (intcol) fits in memory?

That's a likely cause; partitions seem to be a good fit for data warehouses where keys would be too large to fit in memory, meaning lots of disk access.

Some benchmarks on large data sets without primary keys are discussed in Giuseppe's article here:

http://dev.mysql.com/tech-resources/articles/testing-partitions-large-db.html

Options: ReplyQuote


Subject
Views
Written By
Posted
5032
H M
September 04, 2008 12:07PM
2616
September 04, 2008 12:14PM
2630
H M
September 04, 2008 12:36PM
2654
October 03, 2008 10:07AM
Re: Index causing much slower query
2677
October 08, 2008 07:46AM


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.