Received: by 10.42.150.2 with SMTP id y2mr6911279icv.7.1337356188193;
        Fri, 18 May 2012 08:49:48 -0700 (PDT)
X-BeenThere: csharp-sqlite@googlegroups.com
Received: by 10.231.0.164 with SMTP id 36ls2648329ibb.0.gmail; Fri, 18 May
 2012 08:49:47 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.68.239.138 with SMTP id vs10mr2042407pbc.19.1337356187580;
 Fri, 18 May 2012 08:49:47 -0700 (PDT)
Authentication-Results: ls.google.com; spf=pass (google.com: domain of
 mike.d.w...@gmail.com designates internal as permitted sender)
 smtp.mail=mike.d.w...@gmail.com; dkim=pass
 header...@gmail.com
Received: by nw7g2000pbb.googlegroups.com with HTTP; Fri, 18 May 2012 08:49:47
 -0700 (PDT)
Date: Fri, 18 May 2012 08:49:47 -0700 (PDT)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0,gzip(gfe)
Message-ID: <590af84b-19e1-4a1c-8693-f5314dc2d968@nw7g2000pbb.googlegroups.com>
Subject: Performance problems with the CShapr-SQLite library
From: Mike <mike.d.w...@gmail.com>
To: "C#-SQLite" <csharp-sqlite@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

I've searched around for discussions and issues about this but have
not found anything yet.

I have recently started using CSharp-SQLite and I like it. I am having
trouble with performance, though, when executing queries that have
JOIN or ORDER BY calls. When I ran a query in my C# program I got a
reported time of about 0.1 sec, but the same query ran for the
original library in 0.003 sec, which is 30 times faster.

Now this query was a simple SELECT query over about 450 records with
an ORDER BY at the end ordering on one column. I have all my necessary
indexes set along with Primary and Foreign keys, but it does not seem
to make a difference. This kills me when doing these queries on tables
with tens of thousands of records.

I have compiled from source, so there may be a compiler directive I'm
missing or something, I'm not sure. Just figured I'd start a
discussion about it. If anyone knows of a solution please direct me.