Answering in reverse order

> Or maybe I shouldn't worry ?

Set AutoFetchAll on the lookup queries, and they will be in
memory - so there should be no problem.

> Is there a quick alternative way to do lookups ?

As a quick fix, you could change the lookup query to some
thing like

SELECT TITLE FROM LOOKUP WHERE ID = :ID

and just set the ParamByName

> I am worried that retaining this code could make the application too slow.

Once you have it working, changing the slow bit, if they are
a problem, will not cause too many problems.
The method I use everywhere for these sorts of lookup is to
put it in the SQL of the query, so the above example becomes

( SELECT TITLE FROM LOOKUP WHERE ID = TABLE_A.ID ) AS
LOOKUPA_TITLE

so you can dump all the extra code to create it.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services