--- In [email protected], siva subramanian <[EMAIL PROTECTED]> wrote: > > Hi Mikcaau, > Thank for your reply.Can you send me example codings. > Kindly Regards > Siva
Siva, The changes you need to make depend exactly on your database and its use. You need to add a couple of house keeping fields to each table, DateCreated, LastChanged, DateDeleted. These are all datetime Your program needs to have logic so that when you do updates from the server you read all where DateCreated > a local variable LastRead Remove all where DateDeleted not null update where LastChanged > LastRead Then set LastRead from the server You will need to purge your database to remove deleted records. You can manage a lot of caching locally I use Firebird which has events that I set to fire on update and add. Above is the skeleton of letting your machine run on thin wire. Next is to examine the queries that you use most and optimise them. The best I ever did (using indices and tuning) was to take a query that took 3 days to run, initially, and work on it until it ran in under 3 seconds. I took a couple of days to get there but was well worth the effort. I tend to provide a tree managed dataset and records are aparently kept in folders. Users can create folders, move records between folders and the records themselves are TListItems with local storage. This makes the programs easy to use and easy for users to manage. My help files get smaller. Good luck Mick
