Subject AW: [firebird-support] indizes question
Author Olaf Kluge
Hello thomas,

Yes, I have taken the commit-button. I will test this situation again.

Thank you for your friendly help.
> 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
> 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?

Did you commit the index creation? If yes, then I guess its related to
metadata caching of the procedure and trigger executable code for existing
connections. Re-connect should do the trick as well. Also new connections
will see the changes too.

> 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?

Again, metadata caching or even transaction related? How does transaction
management work with Access and the ODBC driver?

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog:



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links