|Subject||RE: [firebird-support] Classic vs Superserver|
|Author||Svein Erling Tysvær|
>>>we sometimes get queries, that normally complete in reasonable time, taking many times as longHmm, do the queries suddenly or gradually drop performancewise? If gradually, it could be a problem with one or more long-running transactions. If suddenly (and repeatedly) it could be
>> This sounds like you are running into the automation database sweep,
>> what is the sweep interval for the database?
a) that Firebird (incorrectly) thinks another plan would be better
b) running under a WAIT transaction if you're trying to update something that (an)other person(s) has changed but not committed yet
These are at least a few possibilities, there could be others.