Thanks to all for the answers.
I will analize then and work in it...
2006/9/5, John Stanton <[EMAIL PROTECTED]>:
You could use brute force and ignorance. Keep a master copy of your
database in SQL form and do a diff on the SQL form of the new DB, then
export the changes as SQL to update the
"Juan Perez" <[EMAIL PROTECTED]> wrote:
>
> 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
nt to see how big your diffile will be.
Hope it helps!
WBR, Denis.
-Original Message-
From: Juan Perez [mailto:[EMAIL PROTECTED]
Sent: Monday, September 04, 2006 9:17 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Best way to compare two databases
(excuse me for the other mail, i clicked a
2006/9/5, JP <[EMAIL PROTECTED]>:
Assumming that the clients will NOT change the original database, I can
think of 2 methods:
1. Whole DB: drop all indices, then vacuum, then zip, then propagate. On
the clients (suscribers), unzip, re-create all indices.
2. Incremental, add a field to stamp
Assumming that the clients will NOT change the original database, I can
think of 2 methods:
1. Whole DB: drop all indices, then vacuum, then zip, then propagate. On
the clients (suscribers), unzip, re-create all indices.
2. Incremental, add a field to stamp the date on all your records, then
(excuse me for the other mail, i clicked accidentally the button...)
Hi:
I think that i explained me bad.
In my work i do next until now:
Phase 1: I generate automatically a database from a CRM
Phase 2: I put the database in the FTP for the commercials of the
enterprise. They are located in
Hi:
I think that i explained me bad.
In my work i do next work:
I generate automatically a database from a CRM
2006/9/4, Paul Smith <[EMAIL PROTECTED]>:
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
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
8 matches
Mail list logo