ling column (I've tried
to add another column "info blob not null") loads entire row (i.e.
including whole data column)...
IOW "select info from content;" retrieves also data column content.
Weird, isn't it?
>
> 2018-08-06 20:59 GMT+02:00, Abramo Bagnara :
&g
Il 04/08/2018 07:07, Abramo Bagnara ha scritto:
> Il 03/08/2018 23:53, Abroży Nieprzełoży ha scritto:
>> -- One table with whole files
>> CREATE TABLE content(
>> id INTEGER PRIMARY KEY,
>> data BLOB NOT NULL
>> );
>> -- And second table wit
/O is faster than using substr(data, start, len) in a
SELECT?
--
Abramo Bagnara
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Il 03/08/2018 21:50, Simon Slavin ha scritto:
> On 3 Aug 2018, at 8:04pm, Abramo Bagnara wrote:
>
>> Some queries will need to extract the whole file, while other queries
>> will need to extract the text for a range of lines.
>
> Can you give us an idea of how many l
it is better/faster the first option, the
second option or a smarter option I've not considered?
My partial considerations are:
- 1 is simpler
- 1 leads to faster load
- 1 is slower to retrieve a range of lines (not 100% sure)
--
Abramo Ba
he point is not about overzealousness, but about the declaration of
memcpy/memset on your machine.
If it contains the nonnull attribute then (correctly) UBSan detect that
such constraint is not respected.
--
Abramo Bagnara
BUGSENG srl - http://bugseng.com
mailto:abramo.bagn...@bugseng.com
|SEARCH TABLE t USING INDEX t_ac (a=? AND c=?)
Although the two queries are equivalent the first form is not optimized
to use available indices.
Is this expected?
--
Abramo Bagnara
BUGSENG srl - http://bugseng.com
mailto:abramo.bagn...@bugseng.com
_
7 matches
Mail list logo