1
Vote

Check performance of count methods

description

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.

comments

MikeLowrey wrote Aug 3, 2011 at 9: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 2:39 PM

MikeLowrey wrote Aug 23, 2011 at 2: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 2:39 PM

wrote Feb 13, 2013 at 11:05 PM