[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: sleep
- From: Marco Antonio Abreu <mabreu.ti@...>
- Date: Mon, 25 May 2009 16:14:26 -0300
thank you for your suggestions. But the unfortunately we do not have access to do anything starting from the database or the O.S.. Only to you know, Windows with MS SQL Server. This server is not in our domain, only client's and they don't want to change anything in their servers (for now).
Thank you again.
On Mon, May 25, 2009 at 2:28 PM, Petite Abeille <email@example.com>
What about using database change notification instead of polling? That way the database calls you when it has some changes, instead of you asking if there are any changes all the time...
On May 20, 2009, at 10:33 PM, Marco Antonio Abreu wrote:
I am writting a script to copy some data from one database to another, this
script will be running all the time, verifying if have something to copy.
I need to wait for some seconds between two checks, to do not overload the
DB server or CPU.
If this was not mentioned already, Luiz Henrique de Figueiredo's lalarm could be used for that purpose:
How can I implement a function (or use if already has) to perform a "sleep",
to wait some (milli)seconds doing nothing.
Marco Antonio Abreu
Analista de Sistemas