Hi -
We have a C++ (VisualC++) app that is reading from and writing to a sqlite
database. Profiling reveals that it is spending 883.437 of its 2160.988
seconds in the sqlite3_win32_mbcs_to_utf8 function. We are using
std::basic_string<wchar_t,...> as our string type and I can only assume that
these are being seen by sqlite as mbcs strings. I would like to know a better
way of doing this that will eliminate all these unnecessary conversions. I
believe it may end up being a combination of picking the correct string type
(although using anything but the type we are using may be difficult if it
contravenes a product-wide standard) and setting the defaults properly in
sqlite. I have attempted the latter by issuing a
m_db.executeStatement("PRAGMA encoding = \"UTF-16\"", error); just after I
create a database. I clearly am not doing this effectively as it seems to have
no effect on the use of the function in question.
Any guidance from older hands would be greatly appreciated.
Thanks.
Michael Clagett
Principal Software Engineer
Mathworks, Inc.
[email protected]<mailto:[email protected]>
(508)-647-4307
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
