MySQL Forums
Forum List  »  Performance

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)
Posted by: aftab khan
Date: February 21, 2009 11:59AM

i suggest you to use table partioning (available in 5.1)at present you are finding it hard to load 350m rows, after that your reports will run slow. Check whether you can partition the data by date, list,range etc..

Options: ReplyQuote

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.