I did debugging with WinDbg and got the following with !analyse:
GetUrlPageData2 (WinHttp) failed: 12002.
DUMP_CLASS: 2
DUMP_QUALIFIER: 0
FAULTING_IP:
ntdll!LdrpDoDebuggerBreak+30
7ffb`0a4871b8 cc int 3
EXCEPTION_RECORD: (.exr -1)
ExceptionAddress: 7ffb0a4871b8
I get confusing (to me) results when toying with a query that I think
should use a partial index as a "covering index". This is using sqlite
3.20.1 on Arch Linux x86_64.
The examples listed below start from a new, empty database.
*** Given a table and an index like this
CREATE TABLE tab (x1
On Sat, Sep 09, 2017 at 11:26:35PM +0200, R Smith wrote:
> I think you are missing something or my explanation was not clear.
> When I say "first test" I mean of THIS test suite, not the previous set from
> 3 days ago.
I meant the opposite.
___
On 2017/09/09 9:20 PM, Nico Williams wrote:
On Sat, Sep 09, 2017 at 05:56:03PM +0200, R Smith wrote:
*Findings* pertaining to JOIN, INTERSECT and WHERE IN (...) type queries on
tables *WITHOUT Row_ids*:
(This is the full test posted below because it is the one that matters most)
INTERSECT AND
On 9 Sep 2017, at 9:11pm, Teg wrote:
> Is it a phone or tablet? I'd wonder if the CPU is going into thermal
> throttle mode. As I understand it most phones and tablets can't keep
> the CPU's running full speed without eventually throttling the CPU.
I would never have
Hello Yue,
Is it a phone or tablet? I'd wonder if the CPU is going into thermal
throttle mode. As I understand it most phones and tablets can't keep
the CPU's running full speed without eventually throttling the CPU.
To me the fact uncompressed, while moving much more data, is more than 2
On Sat, Sep 09, 2017 at 05:56:03PM +0200, R Smith wrote:
> *Findings* pertaining to JOIN, INTERSECT and WHERE IN (...) type queries on
> tables *WITHOUT Row_ids*:
> (This is the full test posted below because it is the one that matters most)
> INTERSECT AND WHERE IN (...) queries posted similar
Full tests completed with findings ranging from less interesting to
exposing a rather significant inefficiency in SQLite.
I won't post all the tests because that would take far too much space,
in stead I will simply discuss the experiment and findings and post the
test script so that anyone
Thanks for the advice. I'll try them now.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
9 matches
Mail list logo