I would expect there to be a speed and memory performance *impact* if the result set contains columns other than the three specified ones, since obviously the library will need to allocate more memory to hold the extra data.
On 10/28/2009 03:52 PM, Pete56 wrote: > 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 ? > -- Cu stima, Mihai Limbasan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users