search

Ngugi1 / sqlite-net

Automatically exported from code.google.com/p/sqlite-net
0 stars 0 forks source link

Linq .Count() is not compiled (VERY slow execution) #20

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Once we get past a couple of rows in a table, 
Connection.Table<SomeClass>().Count() gets really, really slow. As far as I can 
tell, that's because it's never compiled to SQL, so the wrapper constructs the 
whole list then uses the built-in Linq function to count the rows. The 
corresponding "select count(*) from SomeClass" is fast, as expected.

I think you should add a fat warning on the wiki page because it's something 
one doesn't easily notice when working with simple test data. "join" isn't 
implemented either, is it?

Original issue reported on code.google.com by olau%iol...@gtempaccount.com on 6 Aug 2010 at 3:29

GoogleCodeExporter commented 9 years ago 
No JOIN is not yet implemented, but it's my next big feature.

I will work to get Count() compiled in the next release.

Original comment by frank.al...@gmail.com on 11 Aug 2010 at 6:23

GoogleCodeExporter commented 9 years ago 
This is poor.

Original comment by sonnyma...@gmail.com on 27 Aug 2010 at 12:37

GoogleCodeExporter commented 9 years ago 
Fixed in R67.

Original comment by frank.al...@gmail.com on 13 Nov 2010 at 11:41