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