Good answer. Thanks, we may have more questions for you. Kavita
On 12/17/09 10:46 AM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
