>> I'm not sure if this is a problem or not, but I have quite a few
>> entries like this with NULL transaction ID's in the MON$STATEMENTS table:
>>
>> Is this a sign that my code isn't cleaning something up properly, or
>> is it perfectly normal?
>>
>> Any idea under what circumstances this will happen?

>i.e. if the statement is prepared but not currently executed, then its transaction id will be NULL in MON$STATEMENTS.

Ah, thanks Dmitry, I checked it out, and yes it is prepared statements that are not currently open. I just never realised how many prepared queries I actually had - just did a quick select with count on the MON$STATEMENTS table, and I have on average 100 prepared queries per connected user.

Is that not going to be affecting performance in a bad way?

(I have classes that automatically construct the SQL, and sometimes it helps to have a prepared query, but a lot of them will only get re-used a few times - it will be quite an undertaking to change it, but if it's using up resources unnecessarily, it might be worth it)






------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links