[cse491] sqlite performance

[C. Titus Brown]

If your search is taking a long time, don't worry about it; just try
inserting some canned data into your database to test it.  I'd suggest
making up your own 'load-data' dictionaries so that you can test
everything with one set of canned data.

You can also read more about sqlite performance here:

	http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning

I think many of you are doing suboptimal table ordering in your WHERE
clauses; try putting the most specific queries FIRST, i.e. the ones
searching for specific names... My search takes a few seconds only.

--titus
-- 
C. Titus Brown, ctb at msu.edu