Re: [sqlite] Compression for ft5

2018-09-25 Thread Domingo Alvarez Duarte
Hello ! Yes you are right the compression need to be defined by each field that you want to be compressed, I did it because I need some fields that the general size do not justify the overhead of the compression. Cheers ! On 25/09/2018 14:29, Wout Mertens wrote: This is really cool, thanks

Re: [sqlite] Compression for ft5

2018-09-25 Thread Wout Mertens
This is really cool, thanks for sharing! I wonder though, is the compression done per field? I read the source but I couldn't figure it out quickly (not really used to the sqlite codebase). What are the compression ratios you achieve? Wout. On Mon, Sep 24, 2018 at 3:58 PM Domingo Alvarez Duart

Re: [sqlite] compression

2005-09-28 Thread Jay Sprenkle
On 9/28/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: > > > This is from my Gentoo 2005.1 Linux system (home) with whatever packages > it installed a few days ago. > At work I use FreeBSD and I've not used loopback devices there, but the > FreeBSD Handbook (online for free) shows how to do it. > >

Re: [sqlite] compression

2005-09-28 Thread Dennis Jenkins
Jay Sprenkle wrote: On 9/28/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: Your third statement is not true. On Linux (and FreeBSD, but FreeBSD does not have Reiser as far as I know) you can treat a regular file as if it were a filesystem and mount that fiel system via the "loop back" device.

Re: [sqlite] compression

2005-09-28 Thread Dennis Jenkins
Christian Smith wrote: On Wed, 28 Sep 2005, Sid Liu wrote: Is there a possibility that this Reiser 4 be used on a file, rather than a file system? Hopefully on Windows? Reiser FS is a filesystem. It manages files. So it cannot be used on a file. Your third statement is not true.

Re: [sqlite] compression

2005-09-28 Thread Christian Smith
On Wed, 28 Sep 2005, Sid Liu wrote: >Is there a possibility that this Reiser 4 be used on a >file, rather than a file system? Hopefully on Windows? Reiser FS is a filesystem. It manages files. So it cannot be used on a file. Windows NTFS already has compressed files. Right click a file or direc

Re: [sqlite] compression

2005-09-28 Thread Sid Liu
Is there a possibility that this Reiser 4 be used on a file, rather than a file system? Hopefully on Windows? --- Jay Sprenkle <[EMAIL PROTECTED]> wrote: > If you're on Linux read about the Reiser 4 file > system. > They found they could compress the entire file > system on the fly and achieve >

Re: [sqlite] compression

2005-09-27 Thread Jay Sprenkle
If you're on Linux read about the Reiser 4 file system. They found they could compress the entire file system on the fly and achieve higher performance as well. Most CPU's can compress and move data faster because they make up the difference on the slow I/O channels to hard disks. Might be a much e

Re: [sqlite] Compression

2005-01-03 Thread amead
[EMAIL PROTECTED] wrote: Hello all, First of all, allow me to wish everyone a Happy New Year and I hope it'll be a good one for all. My question is (and I've raised this topic back in September, but didn't get back to it since), does anyone have a free/commercial add-on for SQLite v3 to perform

Re: [sqlite] Compression

2005-01-01 Thread info
; To: Sent: Sunday, January 02, 2005 12:42 PM Subject: Re: [sqlite] Compression Compression in the DB is interesting I think the commercial prod mentioned just does a field compress and that is all. In general this only works on larger blob like fiels as the overhead of the compressor is usually so

Re: [sqlite] Compression

2005-01-01 Thread sganz
Compression in the DB is interesting I think the commercial prod mentioned just does a field compress and that is all. In general this only works on larger blob like fiels as the overhead of the compressor is usually somewhat high and lets not forget extra overhead of comp/decomp. The idea I was pl

Re: [sqlite] Compression

2005-01-01 Thread info
s.com - Original Message - From: "Roger Binns" <[EMAIL PROTECTED]> To: Sent: Sunday, January 02, 2005 11:18 AM Subject: Re: [sqlite] Compression My question is (and I've raised this topic back in September, but didn't get back to it since), does anyone have a free/

Re: [sqlite] Compression

2005-01-01 Thread Roger Binns
My question is (and I've raised this topic back in September, but didn't get back to it since), does anyone have a free/commercial add-on for SQLite v3 to perform on-the-fly compression/decompression of data, preferably on a field level (compress just one of the fields, not the whole table)? Re