| Subject | RE: [firebird-support] IS this the right thing to do (trigger) |
|---|---|
| Author | Leyne, Sean |
| Post date | 2008-11-20T20:47:08Z |
Robert,
Sean
> > What is the frequency of running the counts query?What indexes are defined on the BranchSend table?
>
> 15 plus branches checking every 3 minutes. However when the DB gets
> large and lots of other queries are running it can take 40+ seconds to
> complete the sql.
Sean