Subject | Re: [firebird-support] Scale or tune firebird? |
---|---|
Author | David Johnson |
Post date | 2004-11-10T23:55:14Z |
Ann is right - identify the queries that are the worst offenders and see
if you can tune them.
What are the indexes like? A good compound index can make the
difference between a complex query finishing about the time the sun goes
nova and finishing instantly. Can you add a term to the query to force
it to use a better index?
Are you getting a lot of deadlocks? Deadlocks actually hit your system
performance at least three times - the initial query, the rollback, and
then the re-query.
if you can tune them.
What are the indexes like? A good compound index can make the
difference between a complex query finishing about the time the sun goes
nova and finishing instantly. Can you add a term to the query to force
it to use a better index?
Are you getting a lot of deadlocks? Deadlocks actually hit your system
performance at least three times - the initial query, the rollback, and
then the re-query.