Tom Shaw <[EMAIL PROTECTED]> wrote:
> In sqlite 3 I have two tables. city_loc has 156865 entries and
> city_block has 1874352 entries:
>
> CREATE TABLE city_loc (loc_id INTEGER PRIMARY KEY, cc TEXT, region
> TEXT, city TEXT, postalCode TEXT, lat REAL, lon REAL, areaCode TEXT);
> CREATE TABLE
ge-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 17, 2007 5:25 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] retrieval speedup help requested
Try running: analyze city_loc
after adding the index.
RBS
-Original Message-
From: Tom Shaw [mailto:[EMAIL PRO
http://www.sqlite.org/lang_analyze.html
RBS
-Original Message-
From: Anderson, James H (IT) [mailto:[EMAIL PROTECTED]
Sent: 18 February 2007 01:15
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] retrieval speedup help requested
Where does one get "analyze"?
-Origin
Where does one get "analyze"?
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 17, 2007 5:25 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] retrieval speedup help requested
Try running: analyze city_loc
after adding the i
Try running: analyze city_loc
after adding the index.
RBS
-Original Message-
From: Tom Shaw [mailto:[EMAIL PROTECTED]
Sent: 17 February 2007 22:16
To: sqlite-users@sqlite.org
Subject: [sqlite] retrieval speedup help requested
In sqlite 3 I have two tables. city_loc has 156865 entries
5 matches
Mail list logo