On Jun 28, 2013, at 5:54 AM, Christopher W. Steenwyk wrote: > I have a rather large database (11 GB) that has two tables (one with > approximately 500,000 rows and another with approximately 50,000,000 rows). > In this database I am performing a query that joins these two tables to > produce approximately 4.4 billion rows and then uses a GROUP BY and COUNT > to return some values to me.
If your data is somewhat static use aggregate tables which can updated on data change. Regards, Bradley Giesbrecht (pixilla) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
