Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Monday, October 28, 2013 9:13 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Mon, Oct 28, 2013 at 9:02 AM, Mike Clagett <mike.clag...@mathworks.

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

rds initially populated. After manually dropping and recreating the > index (as described above) statement execution time dropped to about 1 ms. > > > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Friday, October 25, 2013 8:14 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Fri, Oct 25

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Fri, Oct 25, 2013 at 6:54 PM, Mike Clagett wrote: > Yet the following oddity still remains: when we create the index > programmatically before adding the rows, it doesn't seem to have any > effect. Both interactively in the Firefox tool and programmatically from >

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On 25 Oct 2013, at 11:54pm, Mike Clagett wrote: > Both interactively in the Firefox tool and programmatically from the second > phase of my application it takes about an average 18ms to do a select -- the > same amount of time without the index even being there at

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Fri, Oct 25, 2013 at 10:05 AM, Mike Clagett <mike.clag...@mathworks.com>wrote: > I believe the code that I use to insert a record may somehow check to > see if it's already there first, which might explain why the index

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Fri, Oct 25, 2013 at 10:05 AM, Mike Clagett wrote: > I believe the code that I use to insert a record may somehow check to see > if it's already there first, which might explain why the index would have > improved performance. > Yes, that would definitely explain a

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

...@sqlite.org] On Behalf Of Richard Hipp Sent: Friday, October 25, 2013 9:42 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Fri, Oct 25, 2013 at 9:27 AM, Mike Clagett <mike.clag...@mathworks.com>wrote:

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

ite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Thursday, October 24, 2013 10:58 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Trying to figure out how to circumvent > sqlite3_win32_mbcs_to_utf8 > > On Thu, Oct 24, 2013 at 10:54 AM, Mike

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

again for all your help. Regards, Mike -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, October 24, 2013 10:58 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Thu, Oct 24, 2013 at 10:54 AM, Mike Clagett <mike.clag...@mathworks.com>wrote: > Hi -- > > This is indeed exactly what is happening.On many occasions the > mechanism is only interested in the first row of a res

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Thu, Oct 24, 2013 at 10:54 AM, Mike Clagett wrote: > Hi -- > > This is indeed exactly what is happening.On many occasions the > mechanism is only interested in the first row of a result set and issues > sqlite3_reset() before the result set is completely

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, October 24, 2013 9:40 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Thu, Oct 24, 2013 at 9:06 AM, Mike Clagett <mike.c

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, October 24, 2013 9:40 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Thu, Oct 24, 2013 at 9:06 AM, Mike Clagett <mike.c

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Thu, Oct 24, 2013 at 9:06 AM, Mike Clagett wrote: > Hi -- > > I finally got a chance to put in the profiling and trace callbacks. Very > interesting stuff, which I am attempting to analyze. One of the things I > am seeing is that none of the SELECT statements

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, October 17, 2013 9:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Thu, Oct 17, 2013 at 9:37 AM, Mike Clagett <mike.clag...@mathworks.com>wrote:

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Thu, Oct 17, 2013 at 9:37 AM, Mike Clagett wrote: > Hi -- > > Okay. This is helpful. It appears the profiler is not doing such a good > job at name resolution. So I've been looking down a wrong path. However, > there definitely is a problem; whether or not I

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, October 17, 2013 8:42 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8 On Thu, Oct

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Thu, Oct 17, 2013 at 8:31 AM, Mike Clagett wrote: > Hi -- > > Okay. It looks like sqlite3_win32_mbcs_to_utf8() is being called from a > number of functions, including sqlite3_value_blob, sqlite3_randomness, > sqlite3_extended_errcode, and sqlite3_os_init.From

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, October 16, 2013 8:07 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

Re: [sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

On Wed, Oct 16, 2013 at 7:51 AM, Mike Clagett wrote: > 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.

[sqlite] Trying to figure out how to circumvent sqlite3_win32_mbcs_to_utf8

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 as our string type and I can only assume