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 >
