Thanks for the input. I did recompile in 64-bit mode with no difference.
I also did try version 3.7.13 and that did run faster. So for whatever reason my shell 3.7.17 (32 or 64 bit) is significantly slower on windows than my 3.7.13 32-bit. On Fri, Jun 28, 2013 at 10:30 AM, og <wis...@lavabit.com> wrote: > I had a similar problem and it was the antivirus (win 7 prof)... My table > has about 63 million > rows and a description very similar to yours... but now I use the same data > for FTS4, etc... > on Debian wheeze (simple workstation... and currently all ok...) example: > > sqlite> select count(*) from parte; > 62468241 > CPU Time: user 33.214076 sys 2.160135 > > sqlite> select count(*) from parte where nome match 'castelo'; > 3834 > CPU Time: user 0.004000 sys 0.000000 > > good luck... :) > > t+ > > > > On Fri, Jun 28, 2013 at 9:54 AM, Christopher W. Steenwyk < > csteen...@gmail.com> wrote: > > > Hi, > > > > I have been struggling with a problem and was hoping I could get some > > insight. > > > > 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. Unfortunately the same query > in > > Windows has been running for 16 hours and still hasn't returned. > > > > In my investigation I found that the pre-compiled exe was faster than the > > C++ wrapper I was using, so my tool actually spawns a process using the > > pre-compiled binary. In linux I am using v 3.7.13 and in Windows I am > using > > v 3.7.17. > > > > Does anybody have a suggestion on how to either improve my overall > > performance or increase my performance on Windows? My general thought is > > that this is caused by the file manager layer in Windows, but I don't > know. > > > > Any help would be appreciated! > > > > Thanks, > > Chris > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users