Re: Technical advice needed regarding polling the database

Is it safe to assume that the user is using one app to view the db while it
is a seperate mechanism or app that is updating the db?

One thing that my team has done is to install SQL Server Notification
Services, and configure it to send a notification to a central location if
the data has changed. Then, when an app starts, it can register itself with
the central location as "interested" in these events. The central store can
either send the events directly to the app, or more appropriately, it can
send the events to a cache management system that uses configuration data to
decide if it should update the cache right away or at a later date.

The user at the client end always asks the cache for data. The cache system
will go to the local db, and if the data is old, or if a message has come in
saying that the data is obsolete, then it can do one of two things: a) it
can return to the caller with obsolete data (and an indicator saying so) or
b) it can hold the caller thread and ask the source system for updated data.

This works for our systems. I hope this helps.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"Nadia Amir" <nadia.amir@xxxxxxx> wrote in message
news:uemdgkzIHHA.1504@xxxxxxxxxxxxxxxxxxxxxxx
I have a database which is very frequently updated .I want an option that
user can specify that after how many minutes he/she wants to see those
changes . Like a mechanism which would do



1.. Poll database after a user defined period and then bring those
changes ,mean while displaying the stale data (like Cache )
2.. Also allow user to choose if he/she wants to see/notify updates as
they come
3.. Can notify change ( if any ) in a particular table occur


I have read a lot about SQLDependency class which is used to data caching
.The reason I am confused is



1. The recommendations are that don't use this feature if your data
is frequently updating (in my case data is frequently updating)

2. The class does Cache data for me but I cant find any mechanism
which would notify me that a change has occurred and how many row in a
particular table are added.



I am confused .What feature I should used . Should SQLDependency class can
do the things I want or these can be done without SQLDependency Cache
feature .



Please advice.



Thanks in advance




.

Relevant Pages

  • RE: [SLE] OO: If you can make it, I can break it!
    ... >then sorts the pending write operations to try minimize disk head ... >> memory to memory copy if you exit the app and then call it back up. ... the cache doesn't know about forms or any application internals. ...
    (SuSE)
  • Re: update framework
    ... Could you elaborate more please on what you are updating. ... trying to incorporate an update feature for it. ... Fetch various binary blobs, then install them ... locally to update either data or the app itself. ...
    (comp.lang.perl.modules)
  • Re: [patch 7/8] fdmap v2 - implement sys_socket2
    ... If the idea behind this FIFO was security (ie not easy for an app to predict next glibc file handle), we/glibc might use yet another FD_SECUREMODE flag, wich ORed with O_NONSEQFD would ask to fdmap_newfdto take the tail of fmap->slist, not head. ... would it be OK to rely only on base randomization and use a LIFO instead? ... We have base randomization, plus LIFO does not mean strictly sequential like legacy allocator, just more compatc and cache friendly. ...
    (Linux-Kernel)
  • Re: Easy - if you know how.
    ... actually writing to disks. ... No read cache, slow write. ... Could I make my system faster by updating all files to 1 second ... This means write access to the hard drive when reading files. ...
    (alt.os.linux.suse)
  • Re: Testing the app issue
    ... I run the app and get the time. ... with a little heft to it like Autocad. ... Just the time it takes to load an array or collection. ... >>>might even be wrong about the hard drive cache. ...
    (microsoft.public.vb.general.discussion)
Quantcast