[dba-SQLServer] Constant Poll: Approaches

Arthur,

Just to simplify the question ( for my benifit)...

"For each new record in tblFiction, you want to analyze EVERY existing record in tblFiction, do something, and mark that record in tblFiction complete?

Thanks,

Mark A. Matte


> Date: Wed, 11 Jun 2008 07:56:26 -0300
> From: fuller.artful at gmail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Constant Poll: Approaches
>
> Thanks for the input, Stuart. Currently I'm thinking that I should try what
> I need using SSIS (small footprint, external process), but I'm still open on
> the subject.
>
> Arthur
>
> On Tue, Jun 10, 2008 at 7:40 PM, Stuart McLachlan 
> wrote:
>
>> Triggers are probably out of the question because you need to process the
>> rows
>> sequentially.
>>
>> Procs with Infinite loops tend to be resource hogs and it's not so easy to
>> program complex
>> business logic in TSQL.
>>
>> I'd go with an external agent.
>>
>> I've got a couple of similar things running. Both use ODBC for the
>> connection and a front
>> end application or service which sits in the background and periodically
>> polls the data base,
>> applies the logic and updates where required.
>>
>> I generally write this sort of thing in PowerBasic with the SQL Tools ODBC
>> package but any
>> environment which can generate small footprint executables, can access
>> ODBC, can
>> "sleep" and can spawn threads will do it.
>>
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>

_________________________________________________________________
Instantly invite friends from Facebook and other social networks to join you on Windows Live™ Messenger.
https://www.invite2messenger.net/im/?source=TXT_EML_WLH_InviteFriends