Hi All
I have a program which is used to display a lot (=10000) of JPEG2000
images. The size is about 25KB.
Using a NTFS filesystem gives quite slow loading speed, thus I decided
to test sqlite. The reading of images is very impressing and much
faster than NTFS :-)
However, when I write the images to the database everything is very
slow and writing 10000 BLOBs takes about 20-30 minutes. As our users
is not that pacient they currently will not use this approach!
Is there anything I can do to speed up BLOB writing?
I have the following "pseudo" C++ code:
SQL = "INSERT INTO Images VALUES ("+IntToStr(Well+1)+",?,?)";
sqlite3_prepare(Picture_DB, SQL.c_str(), SQL.Length(), &Stmt,NULL);
bool Found = Zip->FindFirst("*.*",ArchiveItem);
while (Found)
{
BlobStream->Clear();
Zip->ExtractToStream(ZipName,BlobStream);
sqlite3_bind_text(Stmt,1,ImageName.c_str(),ImageName.Length(),SQLITE_STATIC);
sqlite3_bind_blob(Stmt,2,BlobStream->Memory,BlobStream->Size,SQLITE_STATIC);
sqlite3_step(Stmt);
sqlite3_reset(Stmt);
Found = Zip->FindNext(ArchiveItem);
}
rc = sqlite3_finalize(Stmt);
Hope than anybody can help as I would very much like to use sqlite to
obtain a good reading speed!
Jorgen
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
