Re: [sqlite] SQLITE and the memory

> Le 8 sept. 2019 à 23:12, Philippe RIO <51...@protonmail.ch> a écrit : > > Opening the 256 tables : > sqlite3_open_v2(_lpszTbl,[__iTableNumber],SQLITE_OPEN_READWRITE|SQLITE_OPEN_FULLMUTEX,NULL); Wouldn't you be confusing database tables and files? — Best Regards, Meilleures salutations, Met

Re: [sqlite] SQLITE and the memory

Unused memory is wasted memory. If you have unused memory then you bought something that you did not need. The question I have however is: (a) Why do you have such a crapload of itty-bitty databases? It kind of defeats the whole purpose of having a database at all. (b) Why have you changed

Re: [sqlite] SQLITE and the memory

I use the windows task manager to see how the memory is used Opening the 256 tables : sqlite3_open_v2(_lpszTbl,[__iTableNumber],SQLITE_OPEN_READWRITE|SQLITE_OPEN_FULLMUTEX,NULL); - Kenavo https://md5finder.blogspot.com/ (Never be pleased, always improve) -- Sent from:

Re: [sqlite] SQLITE and the memory

Philippe RIO <51...@protonmail.ch> wrote: > Hello, > I have an application composed of 256 databases. Each database occupied 42Mb > for more than 950 000 records into. > > [samedi 7 septembre 2019 13:11:45] : Number of passwords stored : 244 152 > 645 > [samedi 7 septembre 2019 13:19:28] :

Re: [sqlite] SQLITE and the memory

On 8 Sep 2019, at 2:06pm, Philippe RIO <51...@protonmail.ch> wrote: > These 42Mb are measured after a Vacuum. > When I lauched my application it only opens the databases (all) and the > memory is filled by 57mb just for SQLITE ! How are you opening these database ? Do you have 256 connections,

Re: [sqlite] WITHOUT ROWID

On 9/8/19, t...@qvgps.com wrote: > > One option would be to create a new table with rowid, copy all records from > the old one, delete old one and rename new table. That is the quickest solution. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

[sqlite] SQLITE and the memory

Hello, I have an application composed of 256 databases. Each database occupied 42Mb for more than 950 000 records into. [samedi 7 septembre 2019 13:11:45] : Number of passwords stored : 244 152 645 [samedi 7 septembre 2019 13:19:28] : Closing Log file [samedi 7 septembre 2019 13:19:28] : *** Log

[sqlite] WITHOUT ROWID

Hi sqlite-group, I accidentally created tables WITHOUT ROWID. These tables are filled with some 100MB of data and delivered to customers already. Now I'm looking for way to fix this bug. Is it possible to change (ALTER TABLE?) these tables to still include rowid? One option would be to create