Re: [sqlite] index organized table +compression

[Kurt Welgehausen]

> Does anybody know whether it is possible to compress ...

I don't recall anyone having claimed to have done this.
You can try searching the archives:

  

> ... possible to create index organized tables within SQLite

Not really. If you create an index on all your columns,
SQLite will sometimes execute a select using only the
index, but you'll be storing your data twice.

Regards

Re: [sqlite] index organized table +compression

[Martin Engelschalk]

Hi Martin,

I don't know about compression, but sqlite organizes the data by the 
INTEGER PRIMARY KEY,

which every table contains either explicitly or implicitly.

Martin

Martin Pfeifle schrieb:


Hello,
I just started to consider the use of SQLite for a
rather big project. For this project it would be
beneficial if the database supports index organized
tables. Furthermore, it would be helpful, if we could
compress the data by integrating compression
techniques into the files os.c.
Does anybody know whether it is possible to compress
data by altering/extending the os.c files? Does
anybody know whether it is possible to create index
organized tables within SQLite.
Thanks Martin




___ 
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de
 

[sqlite] index organized table +compression

[Martin Pfeifle]

Hello,
I just started to consider the use of SQLite for a
rather big project. For this project it would be
beneficial if the database supports index organized
tables. Furthermore, it would be helpful, if we could
compress the data by integrating compression
techniques into the files os.c.
Does anybody know whether it is possible to compress
data by altering/extending the os.c files? Does
anybody know whether it is possible to create index
organized tables within SQLite.
Thanks Martin




___ 
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: 
http://mail.yahoo.de