I am searching across two joined tables and am interested in a few parameters:
SELECT a.first a.third b.first FROM a JOIN b ON a.RowID = b.RowID WHERE value = :value Is there any speed or memory performance improvement by using SELECT *, rather than SELECT <specific columns> ? If I know there will only be one item (unique :value) selected (LIMIT 1) can I make any performance improvements ? -- View this message in context: http://www.nabble.com/SELECT-*-vs-SELECT-columns---tp26094999p26094999.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
