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