Every 2 seconds hiting.

I am creating one Call centre database and application. The issue is that
application will hit every 2 seconds to database for checking calls so is
there any optimized way I can use like instead of hiting the database every
2 seconds I use any alternate way ?
Thanks
I don't know what kind of app you are creating but it would seem to make
sense that you notify the app when the appropriate condition occurs vs.
constantly polling the db. Since this is a new app you should consider
using SQL2005. Some of the features such as Notification Services (a
version exists now with 2000 as well) and Service Broker might make your
life easier.
Andrew J. Kelly SQL MVP
"Joh" <joh@.mailcity.com> wrote in message
news:eyiuL$VVFHA.2768@.tk2msftngp13.phx.gbl...
>I am creating one Call centre database and application. The issue is that
> application will hit every 2 seconds to database for checking calls so is
> there any optimized way I can use like instead of hiting the database
> every
> 2 seconds I use any alternate way ?
> Thanks
>