Norman Young wrote:
> D. Richard Hipp wrote:
> > It turns out to be faster to read images directly out of
> > SQLite BLOBs until the image gets up to about 15KB on
> > windows and up to about 60KB on linux.
> > And even for much larger images, the performance difference
> > between reading from
Thanks for the correction.
Sam
On Thu, Feb 14, 2008 at 6:19 PM, <[EMAIL PROTECTED]> wrote:
> "Samuel Neff" <[EMAIL PROTECTED]> wrote:
> > If the images you're storing are larger than the defined page size for
> the
> > database (which is most likely the case) then you can get better
>
On Thu, Feb 14, 2008 at 6:19 PM, <[EMAIL PROTECTED]> wrote:
> "Samuel Neff" <[EMAIL PROTECTED]> wrote:
> > If the images you're storing are larger than the defined page size for
> the
> > database (which is most likely the case) then you can get better
> performance
> > and reduced memory
"Samuel Neff" <[EMAIL PROTECTED]> wrote:
> If the images you're storing are larger than the defined page size for the
> database (which is most likely the case) then you can get better performance
> and reduced memory consumption by storing the images in the file system and
> store only paths to
If the images you're storing are larger than the defined page size for the
database (which is most likely the case) then you can get better performance
and reduced memory consumption by storing the images in the file system and
store only paths to the files in the database. This means reading the
On Wed, Feb 13, 2008 at 7:54 PM, Roger Binns <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Norman Young wrote:
> > We had to exclude references to sqlite3_enable_load_extension and
> > sqlite3_load_extension from within apsw.c, in order to avoid undefined
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Norman Young wrote:
> We had to exclude references to sqlite3_enable_load_extension and
> sqlite3_load_extension from within apsw.c, in order to avoid undefined
> symbol references during the build (python setup.py install).
You should have modified
On Feb 12, 2008 4:04 AM, Roger Binns <[EMAIL PROTECTED]> wrote:
>
> Norman Young wrote:
> > Can this same interface be accessed in Python?
>
> That API has to be wrapped.
>
> > Can this be done from Python via the sqlite3 module? Can you point me to
> > examples?
>
> I have implemented it in APSW
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Norman Young wrote:
> Can this same interface be accessed in Python?
That API has to be wrapped.
> Can this be done from Python via the sqlite3 module? Can you point me to
> examples?
I have implemented it in APSW in the development code (ie not
The documentation outlines the C interface for incremental blob
input/output, and mentions the C typedef for a blob handle.
http://www.sqlite.org/c3ref/blob_open.html
http://www.sqlite.org/c3ref/blob.html
typedef struct sqlite3_blob sqlite3_blob;
Can this same interface be accessed in Python?
10 matches
Mail list logo