MySQL Forums
Forum List  »  Data Warehouse

Large Database Question
Posted by: John McGiles
Date: February 10, 2010 09:30PM

This is a continuation of post: http://forums.mysql.com/read.php?22,353250,353625#msg-353625


I'm sorry I wasn't clear. 3 to 4 GROUPS of inserts per minute after the database is initially populated. There could be 100s of rows to insert per minute for some of these tables. Also, after new rows are inserted, updates do have to be done, which if I'm interpreting correctly from your previous response would block any selects on a MyIsam table?

I am using an auto increment for one of the crucial tables in this project currently so I'm glad to hear that using this is extremely cheap.

Initially, when the database is first being populated, there will be thousands if not tens of thousands of rows to insert per minute, but during this process no one will need to access them except the program that initially inserted them.

Again, sorry, but I'm still working on an example we can use to discuss the design of this database.

Options: ReplyQuote


Subject
Views
Written By
Posted
Large Database Question
8235
February 10, 2010 09:30PM
4744
February 11, 2010 10:27PM
3844
February 12, 2010 08:39AM
3983
February 12, 2010 06:23PM
3825
February 12, 2010 06:33PM
4047
February 13, 2010 01:45AM
3918
February 13, 2010 10:40AM
3717
February 13, 2010 03:38PM


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.