On 21/05/2009 11:43 AM, Wenton Thomas wrote: > What's the execution sequence about " insert ino A select .... from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first,
meanwhile this product (frequently chosen for use on devices with minimal memory and slow pseudo-disk storage) would be buffering up the selected rows where? > then insert all the result into table A; > (2) select a row from B ,then insert the row into table A immediately, repeat > the precess. So the least implausible possibility is ... ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
