yes, i know how to do a pool of statement, i thing i will do it easily ... but now the question is it normal that a "PREPARE" use so much of time ? is it not look like a conception error in the engine ?

--- In firebird-support@yahoogroups.com, "Benno" <iblist@...> wrote:
>
> Hi,
>
>
> >EX: user 1 come and say i want info of obj 1
> >few time after user 2 come and say i want the info of obj 98
>
> >i still don't know how to keep the statement prepared between these 2 query
> >done by 2 different users... but i will investigate
>
> I would have a look at placing a middle tier in your setup, that has a cache
> of prepared queries.
>
> I am a Delphi developer and use kbmMW (www.components4developers.com) as a
> middleware framework. This has mechanisms for caching. It has all kind of
> client connections, including .NET and PHP.
>
> I believe you use PHP, so perhaps there is something similar in PHP too.
>
> Benno Evers
>