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

Can you please stop top-posting, because this removes the context of
your reply. Or do you read a book from the end to the beginning? ;-)

I'm out of this thread.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/

> --- 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
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>