At 16:48 04/09/2006, you wrote:
Hi all:
I have developed a program that uses a sqlite database.
Until now the users downloaded an entire new version of the
database weekly from the FTP server.
But now the database is too big (about 500.000 records) and i want
to make a database actualization system.
So, what is the best way (having the old database and the new one)
to obtain a file with the differences. Something like this:
Hmm, I don't think I'd do it that way. If you do that, then you need
to have a copy of the old & new database to compare.
One way around it is to have a 'journal' table which just contains
all the SQL queries which have been actioned (you have to take care
if you use transactions) along with an incrementing serial number.
Then, the user's software can say 'I have all journal entries up to
252376', and then you can just given them all the journal entries
after that number, and they can run the SQL on their end. which will give.
You can make your routine which modifies the database just keep a
copy of the SQL used whenever the action succeeds, and store that in
the Journal table.
Paul VPOP3 - Internet Email Server/Gateway
[EMAIL PROTECTED] http://www.pscs.co.uk/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------