On 4/18/19, Stephen Chrzanowski wrote:
> I'm wondering
> if there is going to be any optimization internally from SQLite by making
> the page size, say, 180k? (
SQLite handles storing 200KB blobs just fine. It has been doing so
routinely for time out of mind. Do not stress over the details of h
When I get my act together and get un-lazy about it, I want to take a large
set of "small" files and put them into a SQLite database blobs in a table,
then have my app run some kind of CRC check
(CRC32/MD5SUM/SHA1/custom/whatever - Haven't decided on a CRC or just
byte-for byte comparisons) to iden
ink your reasoning
is wrong. If you set the SQLite page size to 128kb, then any time
SQLite needs to write anything, it's going to write an entire erase
sector. Even if SQLite is just updating a tiny piece of data in the
middle of a page. That seems like the worst thing you could do.
You p
>From here
http://download.micron.com/pdf/datasheets/flash/nand/2gb_nand_m29b.pdf you
can se what PAGE_SIZE is
Page size is smallest writeable unit. Technically you can write less
multiple times but as far as I know jffs2 does not use this technique, but
lot of other flash file systems does (jffs f
I am planning to use sqlite on a Linux system with JFFS2 file system on
NAND flash. NAND device that I am using has page size of 2048 bytes and
a erase sector size of 128K. I would like to take advantage of sqlite
rollback for the safety of my database files during power-fail.
As per http://www
On 5/5/06, Felix Schwarz <[EMAIL PROTECTED]> wrote:
The average blob data in my tables is 3859 bytes in size. The
benchmarks were run with 6394 entries each and do necessarily include
application times for working on / creating the data including
additional I/O. But still, it does ilustrate that
Am 26.01.2006 um 02:54 schrieb [EMAIL PROTECTED]:
deminix <[EMAIL PROTECTED]> wrote:
I was curious if a single page of the database was limited to at
most one
record, aka can records be packed into a single page?
Multiple small records can fit on one page. Or a large record
can span multip
Thank you.
On 1/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> deminix <[EMAIL PROTECTED]> wrote:
> > I was curious if a single page of the database was limited to at most
> one
> > record, aka can records be packed into a single page?
>
> Multiple small records can fit on one page. Or a
deminix <[EMAIL PROTECTED]> wrote:
> I was curious if a single page of the database was limited to at most one
> record, aka can records be packed into a single page?
Multiple small records can fit on one page. Or a large record
can span multiple pages.
>
> If it does pack records, then the pur
I was curious if a single page of the database was limited to at most one
record, aka can records be packed into a single page?
If it does pack records, then the purpose of the page size becomes less
obvious to me. It can certainly be used to match the size of the underlying
OS/hardware more effi
FYI, I tried the same script on windows xp2 sqlite 3.2.7, and it worked
fine also
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 01, 2005 7:13 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Page size prob
"Anton Kuznetsov" <[EMAIL PROTECTED]> wrote:
> Hello!
>
> Did anybody try to create an SQLite3 database with a custom page_size (e.g.
> 8192) and fill it with data of more than 1Gb? As for me I didn't
> manage (using tclsqlite-3.2.7). It says "database disk image is malformed".
>
I just testing
Hello!
Did anybody try to create an SQLite3 database with a custom page_size (e.g.
8192) and fill it with data of more than 1Gb? As for me I didn't
manage (using tclsqlite-3.2.7). It says "database disk image is malformed".
Thanks.
Anton.
On Fri, 2005-06-17 at 22:54 -0400, Joel Lucsy wrote:
> I was investigating if file mapping could be used under win32, but
> have run into a roadblock. The win32 documentation for MapViewOfFile
> (which is the part that maps the drive data into memory) wants the
> file offset to be a multiple of the
I was investigating if file mapping could be used under win32, but
have run into a roadblock. The win32 documentation for MapViewOfFile
(which is the part that maps the drive data into memory) wants the
file offset to be a multiple of the allocation granularity of the
system. On my machine (XP Pro)
15 matches
Mail list logo