MySQL Forums
Forum List  »  Performance

Re: Table wirth several billion entries
Posted by: Benoit St-Jean
Date: June 14, 2005 07:09AM

Peter Jefferson wrote:
> Problem is- can I pump a billion or more entries
> into one InndoDB table and still hope to perform
> selects on it? Right now it takes about 1.4ms per
> insert (using jdbc and batch execution). I started
> a test run over the weekend to insert a
> tree-structure. Right now there are 34M entries
> and a select count(KEYID) from TABLE takes 15
> secs. Ok, these results suggest that it is too
> heavy ;-) but maybe I just have a bad setup. Iam
> still new to database handling.

There are known issues with COUNT() on InnoDB tables. In some cases, InnoDB has to perform a full table scan to get the count. MyISAM tables don't have this problem

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Table wirth several billion entries
1736
June 14, 2005 07:09AM


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.