Hello,



actually I’m using firebird 2.1 cs. One procedure took a long time to
execute and the speed analyzer shows me the problem. One non-indexed field
is the reason. I created the index, but the performance did not improve.
Only after I compiled the stored procedure and some triggers again, the new
index will be used.



I create the database objects with EMS Interbase Manager.



What can be the reason?



A second Question.



My ms access front-end connects to odbc. I open my access-application. If I
change some triggers in firebird, my application do as if nothing has
changed! I have just the old functionality. Only it works fine after I have
restart the front-end application (ms access). Then the updated trigger will
be used.



Have you any ideas?



Thanks for helping.





Mit freundlichen Grüßen / with best regards



Olaf Kluge



S A T R O N Sachsen
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau




Tel: +49 (0) 3725 / 3506-31
Fax: +49 (0) 3725 / 3506-12
Mobil: +49 (0) 170 / 9292375
E-Mail: <blocked::mailto:olaf.kluge@...> olaf.kluge@...
Internet: <blocked::http://www.satron.de/> http://www.satron.de/


............................................................................
................
Geschäftsführer: Bernd Grötzschel, Gerd Kaden
Amtsgericht: Chemnitz HRB1218
Ust-ID-Nr: DE141294791



............................................................................
................
Diese E-Mail ist vertraulich. Wenn Sie nicht der beabsichtigte Empfänger
sind, dürfen Sie die Informationen nicht offen legen oder benutzen. Wenn Sie
diese E-Mail durch einen Fehler bekommen haben, teilen Sie uns dies bitte
mit, indem Sie die E-Mail an den Absender zurücksenden. Bitte löschen Sie
danach diese E-Mail.
This email is confidential. If you are not the intended recipient, you must
not disclose or use the information contained in it.
If you have received this mail in error, please tell us immediately by
return email and delete the document.



[Non-text portions of this message have been removed]