It's impossible to diagnose from so little information. Comments on a video are also not the best for such a discussion. You can ask for help on one of the places http://www.orchardproject.net/discussions links to.
@Patrick: The audio version seems to be 44MB, which should be fine on mobile. For the video, maybe it would be better to stream it if possible, or otherwise subscribe to the low quality video version (<150MB). All videos are also available on our YouTube channel https://www.youtube.com/channel/UCvtT19MZW8dq5Wwfu6B0oxw
SQL Server does optimize non-sproc queries pretty well. Contrary to what most people think, they are even faster in a number of cases because the server is often able to create a better execution plan depending on the parameters, as opposed to sprocs that
have a fixed execution plan, which sometimes negates the effect of not having to compile the query.
As always when perf is involved, measurement is the only way to find out.