Re: [sqlite] Virtual memory management of Sqlite core on Windows Mobile 6.5 with .NET CF 3.5

memory used by previous connections seems not to reset. Thanks, Pavlo. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Monday, November 10, 2014 6:27 PM To: General Discussion of SQLite Database Subject: Re

[sqlite] Virtual memory management of Sqlite core on Windows Mobile 6.5 with .NET CF 3.5

o instruct regard memory policies? Thank you in advance for your time. Thanks, Pavlo. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Conditional JOIN

Hey Clemens. Thank you for your reply! > Pavlo wrote: > > What I have is one big table storing all mandatory properties of an entity > > and several small tables, storing optional properties. > > > > So, when I need to select big number of elements using JOIN the p

[sqlite] Conditional JOIN

Cheers. I love to use SQLite engine and I am performance paranoid. Today I had an idea how to optimize complex query with JOINs. What I have is one big table storing all mandatory properties of an entity and several small tables, storing optional properties. If for example big table may have