> I've tried indexing the information that I most commonly look up and avoid
> text
> and other lengthy column types. If you do a lot of indexing that might use
> up a
> lot of storage space though, so there's probably a balance between speed
> and the
> disk space you use up.
As well as taking up alot of space indexing too much will actually also slow
down queries.