Subject | Queries done through ISQL must faster than in production |
---|---|
Author | peterson77 |
Post date | 2010-02-05T21:33:29Z |
A program is running queries in production that take as long as 180 seconds. When I do these same queries against the same database using ISQL, they can take as little as 5 seconds. Why the difference?
The production box is a RHEL 5 Linux running Firebird 2.0 using classic architecture.
Thanks for any help you can offer.
- Steve
The production box is a RHEL 5 Linux running Firebird 2.0 using classic architecture.
Thanks for any help you can offer.
- Steve