Efficiency
Like with in any other storage engine, there are operations that are faster than others and ops that are slower than others. This page should summarize them.
Slow
-
Prepending values. If you have in table pair
("z", "z")
and then you add pair("a", "a")
,("z", "z")
has to be moved to free place for("a", "a")
. -
Using
get('*', 'concrete_col')
orget('*row', $col)
.
Fast
-
Appending values. If you have in table pair
("a", "a")
and then add pair("z", "z")
, it is OK, because("a", "a")
does not have to move. -
Using
get('concrete_row', 'concrete_col)
,get('concrete_row', '*')
orget('row*', $col)
.