> If the schema changes, a listing of every column can be > invalidated, but the asterisk cannot.
This is only partly true. At some point, the code is going to need to grab the individual fields, and that is the point where the asterisk fails to serve you well. If new fields are added to the schema, but those fields are never used, you sacrifice performance. On the other hand, if fields are added to the schema and you need to use them, you still have to modify the code to retrieve and use the column. Adding the new fields to the query at the same time isn't a big deal. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users