Client always views "live" data in memory.

Article View: borland.public.delphi.database

Article #102

Back to borland.public.delphi.database Previous Next

#102

From: Kristof Van Raemdonck
Date: Wed, 06 Aug 2003 17:28

22 lines
1541 bytes

Hello,

If you want to build a client/server database where :

Server : somewhere on the network,
Client : needs to have a quasi realtime "mirror" from the main
database in its own client memory.  They need to have the data in
their own memory, because the clients need to be able to perform very
fast lookups in the table.

I am really looking for a 'smart' system, so not one where I do a
refresh every x seconds.

I investigated to do it with ADO components, but aparently there does
not seem to be any trigger mechanism from the server to the client to
indicate that records were changed/inserted/deleted.

Is Interbase maybe a solution ? 

Can anyone give me a clue about where to start ?

Thanx.

Technical Details

Message-ID: <6fae3eee.0308060928.37a30d48@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,84611e7056d74296,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-08-06 10:28:23 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: kavraemd@icqmail.com (Kristof Van Raemdonck)
Newsgroups: borland.public.delphi.database
Subject: Client always views "live" data in memory.
Date: 6 Aug 2003 10:28:22 -0700
Organization: http://groups.google.com/
Lines: 22
Message-ID: <6fae3eee.0308060928.37a30d48@posting.google.com>
NNTP-Posting-Host: 217.136.59.116
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060190903 22337 127.0.0.1 (6 Aug 2003 17:28:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Aug 2003 17:28:23 GMT