freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Polling tables?

From: James Cameron <james.cameron AT hp.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Polling tables?
Date: 05 Sep 2002 09:30:50 +1000

FreeTDS user query ... is there a way to have the SQL server tell me
when a table or row has been modified?

At the moment, I place the SELECT in a loop, with a few seconds of
sleep(), but that's a bogosity ... I hate polling; it creates load and
still has a response delay. Is there a way I can wait for an UPDATE or
INSERT by another connection on a particular table?

SELECT @@VERSION

Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation Enterprise Edition on
Windows NT 4.0 (Build 1381: Service Pack 6)

--
James Cameron (james.cameron AT hp.com)

http://quozl.linux.org.au/ (or) http://quozl.netrek.org/

Polling tables?, James Cameron, 09/04/2002
- <Possible follow-up(s)>
- Re: Polling tables?, Brian Bruns, 09/04/2002
- Re: Polling tables?, Bob Kline, 09/04/2002
- Re: Polling tables?, James K. Lowden, 09/05/2002
- RE: Polling tables?, Varley, David(CBorn at Alcoa), 09/05/2002