On 17 Dec 2009, at 4:38pm, Kavita Raghunathan wrote: > It is an option to merge tables, but the concern there is that the speed of > lookup maybe compromised?
The speed of lookup will be very small if you have an INDEX which matches what the SELECT asks for. So if, for example your SELECT is SELECT colA, colB FROM myTable WHERE source='aaa' AND colA='BBBB' then the TABLE myTable should have an INDEX (perhaps the primary index) which is on the two columns source,colA For the number of records you quote, this will make the SELECT very fast. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
