Subject TIB_Query parametrized selects and when to unprepare
Author Tanno Vorenkamp
Hi all,

In a web application we have many TIB_Queries for parametrized select
statements
Now I can see two different arguments about when to do an unprepare

1) Only doing an "unprepare" after the SQL has changed, might mean that when
the request is repeated with the same SQL but different parameters we do not
need to re-prepare and therefore we get a faster handling of the requests

2) Doing always an "unprepare" after the select might mean that we prevend
that many TIB_Queries remain claiming recources and handles in the database
while this is not necessary

Could anyone comment on the validness and importance of these argumants and
on what might be the best choice ?

best regards
Tanno