On 28 Jan 2010, at 4:07pm, Tim Romano wrote: > Rather than make a dozen or a hundred round-trips to the webserver, > passing one or a few zipcodes at a time, because that would have > significant latency through the cloud, I am passing the entire list of > desired zip-codes, and getting a single freight train of data in > response (about 200K of data which isn't too bad over broadband).
Concatenate the ZIPcode list into a long separated string: ,zc1,zc2,zc3,zv4, Search it, instead of using IN, by using LIKE. See 'The LIKE and GLOB operators' in http://www.sqlite.org/lang_expr.html and section 4 of http://www.sqlite.org/optoverview.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
