-- Originalnachricht --
Von: "Simon Slavin" mailto:slav...@bigfraud.org>>
An: "SQLite mailing list"
mailto:sqlite-users@mailinglists.sqlite.org>>
Gesendet: 15.10.2019 23:24:17
Betreff: Re: [sqlite] Table was deleted on macOS
On 15 Oct 2019, at
81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail t...@qvgps.com<mailto:t...@qvgps.com>
** +264 (0)81 3329923Nam mobile
** +49 (0)175 7313081 D mobile
** +49 (0)6182 8492599 D office
***/
PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail t...@qvgps.com
** +264 (0)81 3329923Nam mobile
** +49 (0)175 7313081 D mobile
** +49 (0)6182 8492599 D office
***/
___
s
Right.
Was trying it out now, compiling some osm-dbs with primary key generated
with this morton encoding from lat,lon and the performance is even
worse.
Debugging with the sqlite-tool shows, that the page counts for specific
queries are almost double then before.
Seems like, from the sqlite-s
which point during insert are the pages actually written?
-- Originalnachricht --
Von: "Richard Hipp"
An: "SQLite mailing list"
Gesendet: 31.08.2018 15:10:15
Betreff: Re: [sqlite] Strategies to reduce page-loads?
>On 8/31/18, t...@qvgps.com wrote:
>>
>
>
>(3) Consider deliberating choosing INTEGER PRIMARY KEY values based on
>a "Morton code" or "Z-Order curve" of the coordinates.
>(https://en.wikipedia.org/wiki/Z-order_curve) That will cause
>features that are close together geographically to tend to be close
>together within the file.
My prima
ently used?
-- Originalnachricht --
Von: "Richard Hipp"
An: "SQLite mailing list"
Gesendet: 30.08.2018 13:48:30
Betreff: Re: [sqlite] Strategies to reduce page-loads?
>On 8/30/18, t...@qvgps.com wrote:
>>
>>Structure is simple:
>>CREAT
now.
Tom
-- Originalnachricht --
Von: "Richard Hipp"
An: "SQLite mailing list"
Gesendet: 30.08.2018 13:48:30
Betreff: Re: [sqlite] Strategies to reduce page-loads?
>On 8/30/18, t...@qvgps.com wrote:
>>
>>Structure is simple:
>>CREATE TABLE Lines(
Thanks,
Tom
/
** Flemming Software Development CC
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail t...@qvgps.com
** +264 (0)81 3329923 Nam mobile
** +49 (0)175 7313081 D mobile
** +49 (0)6182 8492
9 matches
Mail list logo