[sqlite] How to make sqlite3_release_memory produce a result?

2016-01-06 Thread Bart Smissaert
Have compiled sqlite3.dll (latest) compiled with ENABLE_MEMORY_MANAGEMENT, but sofar not been able yet to make sqlite3_release_memory produce anything else than 0. What would be the simplest way to make this happen? I don't want to do this with C coding, so it should be some SQL scenario or to do w

[sqlite] How to make sqlite3_release_memory produce a result?

2016-01-06 Thread Scott Hess
On Wed, Jan 6, 2016 at 3:03 PM, Bart Smissaert wrote: > Have compiled sqlite3.dll (latest) compiled with ENABLE_MEMORY_MANAGEMENT, > but sofar > not been able yet to make sqlite3_release_memory produce anything else than > 0. > What would be the simplest way to make this happen? > I don't want to

[sqlite] How to make sqlite3_release_memory produce a result?

2016-01-06 Thread d...@marconpies.com
Can someone stear me to a good tutorial to setup and use with windows computer and visual sudio 2008 Tham\nks - Original Message - From: Bart Smissaert Reply-To: SQLite mailing list To: General Discussion of SQLite Database Sent: 1/6/2016 5:03:55 PM Subject: [sqlite] How to make s

[sqlite] {Spam?} SQLite take lower performance while usingshared cache on iOS/Mac

2016-01-06 Thread Scott Perry
The SQLite built into OS X does not support cache sharing for performance reasons?, which is probably why your results are statistically identical and the OP's results are wildly different. You can verify this by checking the return value of sqlite3_enable_shared_cache; on OS X it returns SQLIT

[sqlite] Caveats using Sqlite on JFFS2 ?

2016-01-06 Thread Stelling Carsten
Additionally, to prevent early wearout of your persistent storage, make sure to configure SQLite, such that temporary files are stored in RAM rather than Flash. Compile with SQLITE_TEMP_STORE=3 or use PRAGMA temp_store (https://www.sqlite.org/tempfiles.html). In an embedded system, you should p

[sqlite] The database disk image is malformed

2016-01-06 Thread Kevin
Please note that I have recently had "The database disk image is malformed" errors a month ago. The cause was simply a fault in my original 4G RAM card. I was trying to expand the memory by adding another 4G card. My first card had only 3.6G working. When I was doing about 2.5M inserts, they woul