This project is read-only.

Check performance of count methods


Some count methods currently do a COUNT(*) query, while others do a SELECT query and count the number of results row. Check which performs best (mostly if the second one has a considerable performance overhead) and then change them if necessary.


MikeLowrey wrote Aug 3, 2011 at 10:04 AM

This should be irrelevant since the whole db is loaded in mem and always the first query needs time and any following is quite fast so it wouldn't be a problem to just query all files and do the counting in C# this would eliminate more SQL operations.

wrote Aug 23, 2011 at 3:39 PM

MikeLowrey wrote Aug 23, 2011 at 3:39 PM

Solution: using .Net based methods instead of SQL commands

** Closed by MikeLowrey 23.08.2011 07:39

MikeLowrey wrote Aug 23, 2011 at 3:39 PM

wrote Feb 14, 2013 at 12:05 AM