Hi Tekin,
Welcome to the list. There is currently no authoritative answer to the
question of indexing, but Al Evans reports that
"Working with simulated large databases (with InnoDB tables), my
experience is that adding indexes on lft and/or rgt only slows things
down. The only index that helps is one on parent_id."
My advice would be to just keep an eye out for slow queries and then
try different index setups if you spot a problem.
Krishna
On 4/25/07, Tekin Suleyman <tekin at raid.nu>
wrote:> Hi.
> I''ve just started using BetterNestedSet and have a quick question
about
> indexing. Other than indexes on lft and rgt, are there any other indexes
> which would improve the performance of my queries? Currently using it to
> organise categories in a tree structure.
> Thanks!
>
> Tekin
>
> _______________________________________________
> Betternestedset-talk mailing list
> Betternestedset-talk at rubyforge.org
> http://rubyforge.org/mailman/listinfo/betternestedset-talk
>