how can i use SQLite ? when I register the connector and try to retrieve BLOB field, my session take some seconds to extract BLOB(i.e (4 Seconds)) but I have sqlite.phxsoftware.com for .net and when i use it for same database, the extraction time is 0.0
.my lines of code is below:
Poco::Data::SQLite::Connector::registerConnector();
m_Session = new Session(SessionFactory::instance().create(SQLite::Connector::KEY, "C:\\Images.db"));
Poco::Data::BLOB blob;
*m_Session << "SELECT ColImage FROM Images WHERE ColIndex == :ln", use(nItem), into(blob), now;
BLOBInputStream stream(blob);
m_Reader = new BinaryReader(stream, BinaryReader::UNSPECIFIED_BYTE_ORDER);
after asign the BLOB to stream and asign the stream to BinaryReader I try to read some kind of types like (uint)(bool)(float)(string) and when my reading finished, the interval time between start and end is 4 Second.
I serialized my stream by .NET's BinaryReader into MemoryStream and store bytes of MemoryStream into BLOB field of database. and in c++ read this BLOB field and try to deserialize.
MemoryStream bytes contains multiple images, strings, booleans, floats, unsigned integers and so on.
the Time of extraction is more but my extraction ends successfully.
please help me,
Thanks,
Best Regards.