Re: problem while handling concurrecy

[Jonathan Wakely]

On 14 May 2010 09:09, anindh thomas wrote:
>
> Could you please suggest me possible ways to handle both,the concurrency issue
> as well as the delay.

The database already serialises all queries and updates, and is
probably more likely to get it right. One option is to restructure
your queries so that the concurrency is handled by the RDBMS instead
of by using mutex locks in your process.

As for the delay, the obvious first thing to check is to ensure you
have a suitable index on the table.