I have a grid of 1000 x 1000 cells with their own data as well as 20 years of daily weather data (20 * 365 = 7300 rows) for each contiguous group of 50 x 50 cell.
CREATE TABLE cells ( cell_id INTEGER PRIMARY KEY, other cell attributes, lat, lon, met_grid_id INTEGER ); cell_id met_grid_id ------- ------------ 0 0 1 0 .. 2499 0 2500 1 2501 1 .. 4999 1 CREATE TABLE met ( met_id INTEGER PRIMARY KEY, other met attributes, met_grid_id INTEGER ); met_id met_grid_id ------ ----------- 0 0 1 0 .. 7299 0 7300 1 7301 1 .. CREATE VIRTUAL TABLE cell_index USING rtree ( cell_id INTEGER, minx REAL, maxx REAL, miny REAL, maxy REAL ) The db is about 350 MB with the cell table with 1000,000 rows and the met table with 2,920,000 rows and the R*Tree index. Is there any other better way that jumps out at any of you? -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users