[sqlite] Tool to find out the memory usage of a program

2006-09-04 Thread Anish Enos Mathew
Hi, I want to find out the total and the peak memory usage of a program(in Linux). Is there any tool to find it out.I am inserting 100,000 rows into a table.I want to find out how much memory it is taking ; both the total and the peak. Any body has any idea to which tool

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread JP
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

Re: [sqlite] An estimate on how many users?

2006-09-04 Thread Will Leshner
On 9/4/06, bhyrkas <[EMAIL PROTECTED]> wrote: Also, there is rad developer platform that user SQLite. It deplooys to most handhelds. It deploys to are Palm, Pocket PC, Encore Simputer, Amida Simputer, Symbian OS 6.0, 6.1,7.0 handhelds. As well as Windows PCs and Linux PCs. Believe this or not. I

Re: [sqlite] An estimate on how many users?

2006-09-04 Thread bhyrkas
Also, there is rad developer platform that user SQLite. It deplooys to most handhelds. It deploys to are Palm, Pocket PC, Encore Simputer, Amida Simputer, Symbian OS 6.0, 6.1,7.0 handhelds. As well as Windows PCs and Linux PCs. Believe this or not. I am not kidding. It using SQLite on each of t

[sqlite] Re: A question...

2006-09-04 Thread Cesar David Rodas Maldonado
What i meaning how sqlite do for search b-tree indexs? the index are copy to main memory or the merge is done just in hard disk search for every item? understand my question? On 9/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: Hello to all! I am developing a application for grea

[sqlite] A question...

2006-09-04 Thread Cesar David Rodas Maldonado
Hello to all! I am developing a application for great performance and I want to know how SQLite works for merger two list of index, because as i understand every index is a b-tree right? Please help me because i need great perfomance, i am developing a very large Inverted Index. Thanks to all

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread Juan Perez
(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 dif

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread Juan Perez
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 an

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread Paul Smith
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

[sqlite] Best way to compare two databases

2006-09-04 Thread Juan Perez
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 wa

[sqlite] PRAGMA integrity_check

2006-09-04 Thread Marco Bambini
From the manual: PRAGMA integrity_check: The command does an integrity check of the entire database. It looks for out-of-order records, missing pages, malformed records, and corrupt indices. If any problems are found, then a single string is returned which is a description of all problems.

Re: [sqlite] An estimate on how many users?

2006-09-04 Thread P Kishor
On 9/4/06, Shields, Daniel <[EMAIL PROTECTED]> wrote: > so, such a number would include every user of Mac OS X Tiger and above, as the OS uses SQLite. Dunno the exact > number, but would probablly run into several millions, perhaps making it the most widely used, ACID-compliant > relational da

RE: [sqlite] An estimate on how many users?

2006-09-04 Thread Shields, Daniel
> so, such a number would include every user of Mac OS X Tiger and above, as > the OS uses SQLite. Dunno the exact > number, but would probablly run into several millions, perhaps making it the > most widely used, ACID-compliant > relational database on the third rock from they sun. Its also