MySQL Forums
Forum List  »  Quality Assurance

Speed inserts and selects
Posted by: Lucia Valcarce
Date: November 08, 2011 07:11AM


I'm moving my database to mysql but there is one table that is pretty big (more than 47 million rows for each year) and it takes years to insert all the data.

I already tried everything I found in the forum, partitioning, index, fulltext...and is true it works better but its far away from efficient.

For giving more background: The data base is about hydrological data recorded during the past ten years. In my data base there are three tables: one keeping the objects to be saved, another to save the sensors of each object and the last one and the one which is causing the big problem is where I keep hourly all the information collected for each sensor (this table will have 47 million data for each year int the database)

Is there any way I can performed the inserts in less than 10 hours?

Thank you very much!

Options: ReplyQuote

Written By
Speed inserts and selects
November 08, 2011 07:11AM

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.