MySQL Forums
Forum List  »  Archive Storage Engine

Parallel table scans
Posted by: David Phillips
Date: January 08, 2006 01:18PM

Hello,

We are looking at using the Archive storage engine to store huge quantities of data (billions of rows and terabytes of data). Most of the data will be stored in one or two tables. As every query requires a full table scan, the way to increase speed is to spread the data over many physical disks and scan the table(s) in parallel. What is the best way to accomplish?

Has anyone else used archive tables in this manner?

Thanks,
David

Options: ReplyQuote


Subject
Views
Written By
Posted
Parallel table scans
6256
January 08, 2006 01:18PM
3790
January 08, 2006 02:54PM


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.