Yep, index on columns in the where close in the order they appear solved
this problem. In fact, it was twice as fast as sql server.
On Tue, Aug 16, 2011 at 4:47 PM, Simon Slavin wrote:
>
> On 16 Aug 2011, at 10:05pm, Yonnas Beyene wrote:
>
> > SELECT distinct Table1.Column1,
In the process of converting database from sql express to sqlite, I have the
following query that runs very slow on sqlite compared to sql server:
SELECT distinct Table1.Column1, Table2.Column2, Table1.Column2
FROM ( Table1 INNER JOIN Table2 ON Table1.Column1 = Table2.Column1)
WHERE ( Table1.Prim
Hi,
We are in the process of migrating our .NET desktop applications database
from sql server express to sqlite (system.data.sqlite provider). As part of
the task we converted one the large client databases to sqlite using an open
source tool and tested some of the common queries.
A simple "select
3 matches
Mail list logo
