[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Size of a memory DB?
From:       Christophe Leske <leske () online ! de>
Date:       2008-10-31 11:57:17
Message-ID: 490AF29D.3090202 () online ! de
[Download RAW message or body]


> is there a way to get the size of a :memory: db in the sqlite3.exe 
> command line interpreter?
> Or any other way?
>   
Also, would using a small PRAGMA page_size value decrease the amount of 
memory used?

I think the default size is 4096 bytes, how about 512 bytes for an 
in-memory database with only 3 fields? (string, and two ints?)

-- 
Christophe Leske

www.multimedial.de - info@multimedial.de
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]