rs@sqlite.org>
Sent: Wednesday, July 05, 2006 6:44 PM
Subject: Re: [sqlite] Compressing the DBs?
What platform are you using?
If you are using NTFS filesystem you can just mark the file for
compression
and the OS takes care of it transparently.
--
View this message in context:
http://www.
Gussimulator uttered:
I've been using SQLite for a very short period of time and so far Its
doing a great job for my application (single user, quite a big amount of
data though).
Now, since theres a lot of repetitive data, I thought that compressing
the database would be a good idea, since,
[EMAIL PROTECTED] uttered:
Mikey C <[EMAIL PROTECTED]> wrote:
Not sure what you mean there DRH, but I set compression on one of my database
files on NTFS and file size shrunk from 1,289,216 bytes to 696,320 bytes.
And of course the whole compression / decompression process is completely
On 7/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm guessing that the random I/O behavior of SQLite will
frustrate the compression implemented by NTFS and Reiser.
The end result will be a database file that might actually
take up more space than if it were uncompressed.
I'd be
g>
Sent: Thursday, July 06, 2006 12:04 AM
Subject: Re: [sqlite] Compressing the DBs?
At 6:04 PM -0300 7/5/06, Gussimulator wrote:
Now, since theres a lot of repetitive data, I thought that
compressing the database would be a good idea, since, we all know..
One of the first principles of dat
Not sure what you mean there DRH, but I set compression on one of my database
files on NTFS and file size shrunk from 1,289,216 bytes to 696,320 bytes.
And of course the whole compression / decompression process is completely
transparent to SQLite and if you decide that compression is a bad
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
> On 7/5/06, Mikey C <[EMAIL PROTECTED]> wrote:
> >
> > What platform are you using?
> >
> > If you are using NTFS filesystem you can just mark the file for compression
> > and the OS takes care of it transparently.
>
> The linux OS supports Reiser file
On 7/5/06, Mikey C <[EMAIL PROTECTED]> wrote:
What platform are you using?
If you are using NTFS filesystem you can just mark the file for compression
and the OS takes care of it transparently.
The linux OS supports Reiser file systems. This will compress
on the fly with the compression
At 07:07 06/07/2006, you wrote:
Hello there,
This is what I mean by repetitive data:
Tables:
E:\DirectX90c\
E:\DirectX90c\Feb2006_MDX1_x86_Archive.cab\
E:\DirectX90c\Feb2006_d3dx9_29_x64.cab\
E:\DirectX90c\Feb2006_xact_x64.cab\
E:\DirectX90c\Feb2006_MDX1_x86.cab\
take the right 'path' here...
> Thanks.
>
>
>
>
>
>
> - Original Message - From: "Darren Duncan"
> <[EMAIL PROTECTED]>
> To: <sqlite-users@sqlite.org>
> Sent: Thursday, July 06, 2006 12:04 AM
> Subject: Re: [sqlite] Compressing the D
gt;
Sent: Thursday, July 06, 2006 12:04 AM
Subject: Re: [sqlite] Compressing the DBs?
At 6:04 PM -0300 7/5/06, Gussimulator wrote:
Now, since theres a lot of repetitive data, I thought that compressing the
database would be a good idea, since, we all know.. One of the first
principles of data com
At 6:04 PM -0300 7/5/06, Gussimulator wrote:
Now, since theres a lot of repetitive data, I thought that
compressing the database would be a good idea, since, we all know..
One of the first principles of data compression is getting rid of
repetitive data, so... I was wondering if this is
What platform are you using?
If you are using NTFS filesystem you can just mark the file for compression
and the OS takes care of it transparently.
--
View this message in context:
http://www.nabble.com/Compressing-the-DBs--tf1897195.html#a5190175
Sent from the SQLite forum at Nabble.com.
I've been using SQLite for a very short period of time and so far Its doing a
great job for my application (single user, quite a big amount of data though).
Now, since theres a lot of repetitive data, I thought that compressing the
database would be a good idea, since, we all know.. One of the
14 matches
Mail list logo