27
97%

Ran 08 May 2017 08:29AM UTC

Jobs 1

Files 1

Run time 3s

Badge

Embed ▾

pending completion

Build # 27

Build Type

push

travis-ci

Committed by

gplancke

Commit Message

improve (indexed-queries): Add a way to dump huge array to database...

... before querying in order to "bypass" sqlite limitation of 999 prepared
arguments

For example:

SELECT * FROM places WHERE id in (?, ...999+) becomes
SELECT * FROM places WHERE id in (SELECT value FROM tmp_places_id)

Before that we dumped all ids to a 'tmp_places_id (value TEXT)' table...

There is still room for improvements (and maybe rationalize the code)
But this largely improved big queries performances...

Run Details

199 of 237 relevant lines covered (83.97%)

5.68 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	27.1	08 May 2017 08:29AM UTC	0	83.97	Travis Job 27.1

Source Files on build 27

Detailed source file information is not available for this build.

SimpliField / angular-sql-query / 27
97%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 27

SimpliField / angular-sql-query / 27 97%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 27

SimpliField / angular-sql-query / 27
97%

README BADGES
x