On Sun, 15 Mar 2009, P Kishor wrote: > My only concern is query speed, data integrity (of course, that would be > helped by avoiding redundancy), and ease of querying. If I have a 300+ MB > db, saving 5 or 14 MB doesn't gain me anything.
> I want to do something like this -- > > "Give me all the land and weather data for cell number ?" > > or > > "Give me all the land and weather data for all the cells lying within the box > ?" All the more reason to think carefully about your schema. How would you determine cell number x? Use a book of look-ups? Memorize the location of each ID number? Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
