Is there a way in SQLite, to temporary disable and enable a trigger without
dropping and recreating ?
Tom
--
/
** Flemming Software Development CC
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail
--
/
** Flemming Software Development CC
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail t...@qvgps.com
** +264 (0)81 3329923
** +49 (0)6182 8492599
Thanks guys for all the information.
Now I know, how to proceed.
Tom
:)
Am 31.05.2017 um 22:02 schrieb R Smith:
On 2017/05/31 9:31 PM, Thomas Flemming wrote:
Hi,
maybe, hopefully, I missed something, its still about this database:
http://files.qvgps.com/0-tom-public/Geonames_World_2017.zip
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail t...@qvgps.com
** +264 (0)81 3329923
** +49 (0)6182 8492599
***/
___
sqlite-users mailing list
sqlite-users
s@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
/****
** Flemming Software Development CC
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://ww
*****
** Flemming Software Development CC
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
** mail t...@qvgps.com
** +264 (0)81 3329923
** +49 (0)6182 8492599
***/
___
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Thomas Flemming
Gesendet: Dienstag, 30. Mai 2017 18:15
An: sqlite-users@mailinglists.sqlite.org
Betreff: Re: [sqlite] SELECT WHERE with RTREE and second condition slow
force it to go the way you want by using "cross
oun...@mailinglists.sqlite.org] On
Behalf Of Thomas Flemming
Sent: Monday, May 29, 2017 9:28 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SELECT WHERE with RTREE and second condition slow
Ok, here is a sample to try these queries:
http://files.qvgps.com/0-tom-public/Geonames
d need to be LONG because the source for this column is really
containing 64-bit values (osm-ids).
Tom
Am 30.05.2017 um 13:29 schrieb Wolfgang Enzinger:
Am Mon, 29 May 2017 14:27:56 +0100 schrieb Thomas Flemming:
Ok, here is a sample to try these queries:
http://files.qvgps.com/0-tom-
< 30.46203 AND x1 > 30.00074766
AND 18 BETWEEN z0 AND z1
AND Pois_bb.Id = Pois.Id
AND styleid IN (9,48,73,200,142,31,219);
Thanks,
Tom
Am 27.05.2017 um 12:04 schrieb Thomas Flemming:
Hi,
I have
400 schrieb Richard Hipp:
On 5/27/17, Thomas Flemming <t...@qvgps.com> wrote:
Hi,
I have a table Pois with points of interest (geogr. coordinate, label,
styleid) where I do regional querys using a rtree-index:
SELECT Pois.* FROM Pois_bb, Pois WHERE y0 < -14.8600 AND y1
essional 3.5 for testing).
Any ideas, how to speed this up?
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
org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
/****
** Flemming Software Development CC
** Thomas Flemming
** PO Box 81244
** Windhoek, Namibia
** http://www.quovadis-gps.com
**
d in your software;
This is extremely fast, only the initial query will take some time.
What you can't do is query an insane amount of rows EVERY time the user moves
the cursor or scrolls the page, there is no system in existence that will do
that quick, ever.
Good luck!
Ryan
On 2017/05/
te-users-boun...@mailinglists.sqlite.org] On
Behalf Of Thomas Flemming
Sent: Wed 24 May 2017 10:37
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Almost, but when you compare to a telephone directory, then the use case of
fast scrolling down in a
nt by doing a search.
Surely you have a unique key for the list?
-- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
-Original Message- From: sqlite-users
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas
Flemming Sent: Wednesday, 24 May, 2017 02
slow the more down we go.
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
** +49 (0)6182 8492599
17 matches
Mail list logo