Message from discussion Performance problems with the CShapr-SQLite library
Received: by 10.42.150.2 with SMTP id y2mr6911279icv.7.1337356188193;
Fri, 18 May 2012 08:49:48 -0700 (PDT)
Received: by 10.231.0.164 with SMTP id 36ls2648329ibb.0.gmail; Fri, 18 May
2012 08:49:47 -0700 (PDT)
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)
Received: by nw7g2000pbb.googlegroups.com with HTTP; Fri, 18 May 2012 08:49:47
Date: Fri, 18 May 2012 08:49:47 -0700 (PDT)
X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0,gzip(gfe)
Subject: Performance problems with the CShapr-SQLite library
From: Mike <mike.d.w...@gmail.com>
To: "C#-SQLite" <email@example.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.