Timeline for best way to store huge data into mysql using java
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 12, 2012 at 4:11 | vote | accept | Felix | ||
| Jul 29, 2012 at 13:36 | vote | accept | Felix | ||
| Aug 12, 2012 at 4:11 | |||||
| Jul 24, 2012 at 4:46 | answer | added | Dojo | timeline score: 0 | |
| Jul 24, 2012 at 2:52 | answer | added | Chan | timeline score: 1 | |
| Jul 24, 2012 at 2:44 | answer | added | Jeff Storey | timeline score: 0 | |
| Jul 24, 2012 at 2:30 | answer | added | Joshua Martell | timeline score: 1 | |
| Jul 24, 2012 at 1:37 | comment | added | Felix | maybe few words in a talk message. sorry it is about one billion messages a day@OllieJones | |
| Jul 24, 2012 at 1:22 | comment | added | O. Jones | Please give more information about this problem. How big is the typical "talk message"? In what ways do you need to retrieve these messages once they're in your database? 200K a second is, of course, upwards of seventeen billion messages a day. Really? | |
| Jul 24, 2012 at 1:20 | review | Close votes | |||
| Jul 24, 2012 at 8:59 | |||||
| Jul 24, 2012 at 1:20 | answer | added | Ram G | timeline score: 0 | |
| Jul 24, 2012 at 1:19 | history | edited | O. Jones | CC BY-SA 3.0 |
added 13 characters in body; edited body
|
| Jul 24, 2012 at 1:13 | comment | added | Rob |
You probably want to use insert delayed but this is probably a better task for nosql. May i suggest mongodb?
|
|
| Jul 24, 2012 at 1:13 | comment | added | Russ Clarke | If you're inserting that much data; I think an Index will be needed at some point! With that much bulk of data, then I wouldn't do a message by message insertion, bulk import will be much more performant. | |
| Jul 24, 2012 at 1:10 | history | asked | Felix | CC BY-SA 3.0 |