Simon Slavin wrote: > On 15 Sep 2012, at 12:08pm, Elefterios Stamatogiannakis <est...@gmail.com> > wrote: > >> What i would really like to have in SQLite concerning OLAP, would be bigger >> pages, > > You can set pagesize for a new database using a PRAGMA: > > <http://www.sqlite.org/pragma.html#pragma_page_size> > > The maximum allowed pagesize is 65536 bytes. Create a new database file, > then issue the PRAGMA before any CREATE commands. If you have an existing > database and want to change it you have to export the data, make a new > database and import the data again, but this can all be done in two commands > to the shell tool.
Hint: look for VACUUM in above page (well, VACUUM is not much different from export+import pair internally). >> and internal page compression in a similar manner that column stores do [^]. >> This would greatly alleviate the storage pain of using denormalized DBs >> which is a must for OLAP. > > This feature would indeed be suitable for a server-client database engine > designed to run on multipurpose computers. But SQLite is designed more in > embedded machines in a single-processor environment. For example, my TV > recorder uses it to list the TV channels and meta-data about its recordings, > and I have an extremely low-power GPS device which uses it for Positions of > Interest. The fact that SQLite turns out to be so useful as an embedded DBMS > inside, for example, a web browser is just a bonus. As the documentation > says, if you need network-savvy client-server stuff, look elsewhere. > > Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
