Sunday, 15 April 2012

Should I create an Index for a large insert operation in mysql? -


Indicates that I have the following table with 8 billion columns: topic text, fix text, object text and now I want to create another table for calculating different text values ​​like this:

  Make Tablet Nodes (ID Beginning Unsiled Primary Key Auto Impressions, Well Text, counting countless countless); Insert in nodes (Val, Count) SELECT Subject, counting as COUNT (*) with Triples GROUP BY topic  

Will increase the index and object on the subject or the speed of entry ?

A very common rule of thumb: index usually writes lack speed , While increasing reading speed.


No comments:

Post a Comment