On 16/03/2009 11:00 AM, P Kishor wrote: > 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. > [snip] > CREATE TABLE met ( > met_id INTEGER PRIMARY KEY, > other met attributes, > met_grid_id INTEGER > ); [snip]
> 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? How many unique sets of "other met attributes" are there? If the answer is substantially less than 2,920,000, you could consider parking those on yet another table, referenced from the "met" table. Cheers, John _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
