sangoku Posted December 27, 2010 Share Posted December 27, 2010 Hy i have a bit of a dilemma i have a bit of a dilemma, am making a keyword database and am stuck with few 2 options that i can think of. 1. use a auto increment row together with a crc row which represents the value of the keyword, so all in all 2 int rows and 1 varchar row 2. use just a simple varchar row and reference it. but here is the tricky part: i have make 2 indexes in the first case. One for the crc value and one for the auto increment value. And in other one i need only 1 index which would hit 100%of the time while the first one would have duplicate entries (crc values are not unique) so i would have to post calculate it... My question is which is more smart/faster to use the index on a varchar column or to use 2 int indexes?? Keywords can become pretty long more than 25 chars and can also be small like 4-5 chars... AND there will be no deletes means no delete and mazbe some small edits but not in the row that is indexed. Quote Link to comment Share on other sites More sharing options...
sangoku Posted December 29, 2010 Author Share Posted December 29, 2010 None?? QQ Ok maybe this will help the table will contain more than 1 mil records and 1 row with a timestamp. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.