Search Speed Tests

All tests were done via PGAdmin after extracting base queries from the system. "Record Stats" refers to an in-progress experiment of my own for speeding up visibility checks.

Search:
keyword: green

None (deleted check only):
	1000 results: ~980ms (1000 real)
	10000 results: ~1960ms (10000 real)
Current Master:
	1000 results: ~1835ms (1000 real)
	10000 results: ~2820ms (10000 real)
Record Stats:
	1000 results: ~1040ms (1000 real)
	10000 results: ~2015ms (10000 real)
Stored proc:
	1000 results: ~1175ms (981 real)
	10000 results, single pass: ~3820ms (9715 real)
	10000 results, 10 passes: ~10000ms (9715 real)

Limited to one branch:

None (deleted check only):
	1000 results: ~980ms (1000 real)
	10000 results: ~1960ms (10000 real)
Current Master:
	1000 results: ~880ms (1000 real)
	10000 results: ~985ms (1943 real)
Record Stats:
	1000 results: ~800ms (1000 real)
	10000 results: ~900ms (1943 real)
Stored proc:
	1000 results: ~1120ms (206 real)
	10000 results, single pass: ~3225ms (1769 real)
	10000 results, 10 passes: ~10040ms (1769 real)