Re: polling a database

mattia.pascal@xxxxxxxxx wrote:
Hi everybody,
a suggestion, please. I have an application A that modifies the
records of an access database. I should write an application B
(running on the same machine) that monitor these changes, without
modifying application A. I think the only solution is polling the
database and check every record in the table. I realized an
application that reload periodically in memory all the records (I use
an oledbdatareader,

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.

stayng always connected) and compares them with
the previous loaded records. Unfortunately the database is very large
and this procedure takes 2s on a Pentium IV. Do you know any better
method or some tips I could use to improve the performances? I tried
using a dataset and working disconnected, but it's slower (3s).
Thanks.

Add a DateModified field to the table and update that field with the current
date and time whenever the record changes. Then you only need to check the
records that were modified since the last time you checked.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Set the value of a textbox
    ... I need a sample of ASP code, VB or Java script to set the value of a textbox ... once I return values from the database or perform a calculation for example. ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Double quotes
    ... Abdul Azeem wrote: ... > into database, second this inserted value I have display in a textbox ... Already asked and answered on another newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetsdk.programming.scripting.vbscript)
  • Re: How to suppress a duplicate previous comment for a row
    ... > I'm grabbing info from a database. ... Never ask a database-related question without telling us the type and ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: built Application C# using among different VLANS???
    ... and using ADO.NET 2.0 to access database. ... When you post to the appropriate newsgroup, ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • RE: Restore public folders and companyweb
    ... Thank you for posting in the SBS newsgroup. ... I understand that the Public Folder Store ... database cannot be mounted due to integrity problems, ...
    (microsoft.public.windows.server.sbs)