Re: [sqlite] Large Database Windows vs Linux

2013-06-29 Thread Jeremy Nicoll - ml sqlite users
Roger Binns wrote: > Here is the list of monitored extensions: > > http://msdn.microsoft.com/en-us/library/windows/desktop/aa378870(v=vs.85).aspx That's a frighteningly long list - 574 separate extensions... And they're not all obscure ones either. For example it includes .DATA .SRC

Re: [sqlite] Large Database Windows vs Linux

2013-06-29 Thread Olaf Schmidt
Am 28.06.2013 14:54, schrieb Christopher W. Steenwyk: 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

Re: [sqlite] Large Database Windows vs Linux

2013-06-29 Thread Bradley Giesbrecht
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 appro

Re: [sqlite] Large Database Windows vs Linux

2013-06-29 Thread James K. Lowden
On Fri, 28 Jun 2013 08:54:07 -0400 "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 prod