On Fri, 2011-05-13 at 12:11 +0200, Samarendra Pratap wrote: > Comparison between - single index Vs 21 indexes > Total Size - 18 GB > Queries run - 500 > % improvement - roughly 18%
I was expecting a lot more. Could you test whether this is an IO-issue by selecting a slow query and performing the exact same search with that query several times? The OS cache should kick in quickly so that the storage isn't touched at all on the later searches. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
