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
