Skip to Content.
Sympa Menu

freetds - Polling tables?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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/





Archive powered by MHonArc 2.6.24.

Top of Page