Replying to the list so that others also may read.

At 09:49 19.08.2002 +0000, you wrote:

>The real problem is that it was all working ok about a week ago. The
>test db which is an older identical copy is working fine. And yes we
>did a back up and restore. Only the deplhi app on the live db is
>affected, the same app which points to the test db is ok!!!!

Well, there must be some difference between the production and your
"identical" copy and you haven't told us much about your setup beyond which
machine/operating system/development platform you are using. What would be
more useful would be to see the plan selected on both databases (if you do
not know how to do this, just download IB_SQL from www.ibobjects.com,
insert your query in the cursor tab and prepare them). If there is a
difference there, we may be able to help you, but currently none of us have
any clue. Also, tell us about any indexes defined for the tables in
question, as well as the approximate number of records of each table. My
guess would be that someone have created or deleted an index in your
production database, but that is a guess along the lines of "Maybe you're
out of gas?" when someone phones: "My car just stopped. HELP!" without
further explaination.

Still, I hope this helps,
Set