Bob Cardillo <bob.cardillo <at> gmail.com> writes: > CREATE INDEX bobindex1 ON nodes (kind, presence, op_depth)
As one of Bob's coworkers, who helped him a bit earlier last week to track down the --non-recursive trick that improved the speed, I had to try this myself after seeing the results of his investigation over the weekend. The performance improvements are astounding! Even though we are using the same repo, I have a much different pattern of checkouts utilizing depths much more, and the responsiveness after creating this provisional index were amazing. To test this further I tried it on my Ubuntu machine with a different repository which I've also noticed has had a lot of slowness. It is the boost reposository, with trunk checked out as well as many other branches -- nearly a million individual files in all. I am seeing similar significant improvements after creating the index; some operations that would stall for several seconds are now nearly instantaneous. -Adam D. Walling
