Subject | TIB_Query parametrized selects and when to unprepare |
---|---|
Author | Tanno Vorenkamp |
Post date | 2002-11-25T10:35:25Z |
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
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