Index in space usage section in MySQL -
i worried index. file size 25mb, when export sql, file size grows 57mb.
does have idea index? , disadvantages?
it depends on doing. possible index(es) take more (or more) actual data.
you should revise indexes have , whether necessary , used queries, , drop ones not referred anything.
it typical newbie mistake when create lots of indexes every field - can that, waste lot of space needlessly.
while indexes speed searches, many indexes may expensive upkeep, , make updates , inserts slower.
Comments
Post a Comment