We have moved to GitHub Issues
Created by Stefan Tolpeit 11 Jun 2013, 06:35:22 Updated by Claus Jensen 17 Jan 2017, 09:06:32
Relates to: U4-1970
Depends on: U4-1970
With the MiniProfiler i found out that Umbraco makes 2 roundtrips to the database with the same query. The CmsTemplate will be queried twice.
I just found out when de Query will executed twice. If you have a nested template in your Umbraco at example: The Home Template has a _Layout as parent.
I guess that's the whole point of having nested templates. :-)
But I hope they will fix this soon. Not that my site is slow, just waste of time spending 10% of the time i the SQL database for every request, when it's not really needed.
it's not exactly a duplicate reader, but i see 2 sql roundtrips with TemplateId and MasterTemplateId.
See method PerformGet(int id) in TemplateRepository, where the Master template will be loaded.
Edit: seems to be related to http://issues.umbraco.org/issue/U4-684
Edit: seems TemplateRepository does not cache - see use of NullCacheProvider
Edit: How do high-traffic sites deal with those database roundtrips on every request?
How do high-traffic sites deal with those database roundtrips on every request?
Backwards Compatible: True
Affected versions: 6.1.1
Due in version: 6.1.3