On Fri, 28 Jun 2013 08:54:07 -0400 "Christopher W. Steenwyk" <csteen...@gmail.com> 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. > > I struggled with the slowness of this query for a while in linux and > through covering indexes, ANALYZE, and a SSD I was able to get the > query to run in about 15 minutes which I am OK with. Could I ask how much RAM is in the machine? I would like to believe that ~16 GB of RAM would make the I/O speed irrelevant because the OS would cache the database in RAM. I also suspect that Windows is less likely than Windows to devote RAM to I/O cache. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
