-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 钱晓明 wrote: > I want to store image data into sqlite by spliting image to many > blocks(256*256pixels).
Why are you splitting it? You can use the incremental blob api for access http://sqlite.org/c3ref/blob_open.html > The table has the 32K page size, > and I make these pragma: journal_mode = OFF, synchronous = OFF, locking_mode > = EXCLUSIVE, temp_store = MEMORY, compiling sqlite3 with no thread safety. At this point you aren't really using SQLite as a database, but more like a container with SQL queries and easily corrupted. > I have a image file about 400M, in tiff format. You would likely be far better off using the filesystem to store the tiles and then storing the filenames in the database. As a bonus the image API you use will be able to directly load the tiles. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkbvvUACgkQmOOfHg372QSdTwCfd4v7V52+ICGt5+IXueUDFha7 ox4An2IrDiqcOBeCG+KnwrGY4um+Cd2a =VL+4 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users