I'm working on a design for a database that has as its goals two things. First, speed and second, size. The database will be deployed to a hand held device so memory/storage size is an issue.
When doing a select something like one of the following two cases which would be faster? 1. SELECT * FROM xxx WHERE . ID>=StartVal and ID=EndVal and Street like.; 2. Either creating a temporary table or having one already exist, see previous message about max number of tables, then selecting only with Streetas the ERE clause Thanks in advance for any suggestions. Egards, J. R. -------------------- J. R. Westmoreland E-mail: j...@jrw.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users