Re: polling a database

How about letting A make a log of any changes (maybe to a text file) and let B pick that up.
It would save searching the whole database.

RBS

<mattia.pascal@xxxxxxxxx> wrote in message news:1177774097.764893.47460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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, 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.


.

Relevant Pages

  • RE: Database running over network runs extremely slow
    ... I have reports built into the database that track the entry ... you are searching (or using in your DLOOKUPs criteria parameter)? ... of the DLookups to looped recordset searches, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many names and addresses can you have for ID card
    ... large amount of database space, ... Searching CLOBs is thus memory and CPU-intensive, ... A directory system a la LDAP or X.500 would be a much more natural ... An entry may have any number of atrributes which are ...
    (uk.legal)
  • Re: Mysql Search
    ... Try using explodeto put the data into an array, then searching them with ... > I'm not sure if I understand how your database looks like does - does it ... The user inputs a search word to an HTML form which then ... >> has that single letter anywhere in it. ...
    (alt.php)
  • Re: Is there anynone who knows a chatting site or someting like this? - Face Matching
    ... and then you would search your database to find matching ... advance by searching the internet retrieving ... URL and the feature vector to your database. ... You would compare the ...
    (sci.image.processing)
  • Re: What are the other options against Zope?
    ... >> a web app that googles into my companies proprietary database. ... The web part, or the searching part? ... > database interfaces other than to its own ZODB. ...
    (comp.lang.python)