Slow Searches - Valentina

 

Compatibilities: Required Xtras: Valentina

This item has not yet been rated

Searching through the database is very slow what is wrong?

First of all you should go through the fields in your database and check if they are of a realistic size. E.g. don't use 100k as the segment size for a text field if your text averages on 1k. Also re-check the field types you use and see if you can "downgrade" them to a smaller type. This usually boosts the speed. Finally check your indexes. Do you index the fields you are searching on. Doing so will speed the searches up further.