Page 2 of 2

Posted: Tue Jul 19, 2005 2:38 pm
by nielsene
Well you'll want to be a little more selective than that :) Indices will slow down inserts/deletes/updates slightly, but speed up selects. This looks like its an application where data is being inserted more of less continuously (logging), while selects are more user driven and rare? If that's the case you'd be hurting "general preformance/throughput" in favor of a less common operation. "Tuning" a database is almost always about such tradeoffs.

Posted: Tue Jul 19, 2005 2:47 pm
by AlbinoJellyfish
WOW, ok thank you. I learned something new today from both of you. Got it from 45 seconds to 12 by combining some of the sql with the indices made a big difference.