Reply to thread

Message

<blockquote data-quote="Inker" data-source="post: 150627" data-attributes="member: 10541">Are both of you using Logos? I've just done some profiling and I really don't think its because of SQL. I tried with and withou an index on the firstaired field and the time difference was really neglitatable (sometimes without an index was even faster...go figure). I think the reason might be logos.For me SQL took 240ms, logo engine took 400 ms and getting the series name extra (technical reason because latest is a flat view so hierarchy up elements arent in memory and have to be loaded, same reason logo building took so long in this view) took 120 ms. That adds up to about .75 secs or so.Now I just introduced some more aggresive caching for the logo engine, which on first view causes the logo time to drop to about half, and on further views (until a database update occurs such as an online refresh) down to below 40 ms. So total time for me is now about .5 secs for first view, and about .3 secs for views after that.After I cleaned up the debug msg and profiling code I'll update a new svn tomorrow. If you guys could try that and tell me if it improved things.Thnx</blockquote>

[QUOTE="Inker, post: 150627, member: 10541"] Are both of you using Logos? I've just done some profiling and I really don't think its because of SQL. I tried with and withou an index on the firstaired field and the time difference was really neglitatable (sometimes without an index was even faster...go figure). I think the reason might be logos. For me SQL took 240ms, logo engine took 400 ms and getting the series name extra (technical reason because latest is a flat view so hierarchy up elements arent in memory and have to be loaded, same reason logo building took so long in this view) took 120 ms. That adds up to about .75 secs or so. Now I just introduced some more aggresive caching for the logo engine, which on first view causes the logo time to drop to about half, and on further views (until a database update occurs such as an online refresh) down to below 40 ms. So total time for me is now about .5 secs for first view, and about .3 secs for views after that. After I cleaned up the debug msg and profiling code I'll update a new svn tomorrow. If you guys could try that and tell me if it improved things. Thnx [/QUOTE]

Verification