[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.
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
-
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
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
>
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
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
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
...@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:
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
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
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
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
[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
[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
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
...@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:
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
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
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
-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
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.
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
22 matches
Mail list logo