[sqlite] static sqlite database

2015-06-11 Thread Igor Stassiy
Eduardo, I need to do range searches based on id's so R-tree doesn't help, but your suggestion of attaching database sounds useful. I will also look at the size of the page and post my results. On Wed, Jun 10, 2015 at 7:19 PM Eduardo Morras wrote: > On Wed, 10 Jun 2015 14:13:29 + > Igor

[sqlite] static sqlite database

2015-06-10 Thread Eduardo Morras
On Wed, 10 Jun 2015 14:13:29 + Igor Stassiy wrote: > Thanks for all your replies. Please let me clarify: > > I need to do certain range operations efficiently and I prefer SQL > functionality, plus SQLite gives a cross platform file storage > format. The table having 3.2 megabytes is just

[sqlite] static sqlite database

2015-06-10 Thread R.Smith
On 2015-06-10 02:45 PM, Igor Stassiy wrote: > Hello, > > I have a question about controlling the size of sqlite database containing > records of the form id -> payload where payload has fixed size and id is an > integer column. > > I am developing a simple storage for points in an sqlite

[sqlite] static sqlite database

2015-06-10 Thread Igor Stassiy
15 14:45 > An: sqlite-users at mailinglists.sqlite.org > Cc: Kirill Afanasev > Betreff: [sqlite] static sqlite database > > Hello, > > I have a question about controlling the size of sqlite database > containing records of the form id -> payload where

[sqlite] static sqlite database

2015-06-10 Thread Hick Gunter
[mailto:istassiy at gmail.com] Gesendet: Mittwoch, 10. Juni 2015 14:45 An: sqlite-users at mailinglists.sqlite.org Cc: Kirill Afanasev Betreff: [sqlite] static sqlite database Hello, I have a question about controlling the size of sqlite database containing records of the form

[sqlite] static sqlite database

2015-06-10 Thread Igor Stassiy
Hello, I have a question about controlling the size of sqlite database containing records of the form id -> payload where payload has fixed size and id is an integer column. I am developing a simple storage for points in an sqlite database, the problem is that space consumption on disk is

[sqlite] static sqlite database

2015-06-10 Thread Richard Hipp
On 6/10/15, Igor Stassiy wrote: > Hello, > > I have a question about controlling the size of sqlite database containing > records of the form id -> payload where payload has fixed size and id is an > integer column. > > I am developing a simple storage for points in an sqlite database, the >