Ticket

1.10 Very Poor Performance with Local / Live - huge wait times?

Hi All, I have recently completed my first Orchard Website - completed maybe slightly enthusiastic, as it's not without a very glaring bug/problem: huge TTFB delay and sluggish page requests thereafter.

I believe it is something to do with a custom module that I developed that acts as a theme selector for the current Url. The speed problems occur both locally and live, but obviously much more pronounced Live [windows Azure]. e.g. 30-40's TTFB, then 5-8s between page requests.

As I receive no log errors / warnings, I'm slightly at a loss as to how I should go about discovering the cause of the delay? Can anyone recommend a debug approach, as my skills are most definitely in their infancy and I have no idea where I should begin. Thanks in advance, PP

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

Use a profiler.

Tuesday, March 22, 2016 5:38:09 AM bybleroy
  • bleroy
  • Lv. 08 Rookie
  • Total EXP: 527

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

Thanks bleroy, this feels like a red/blue pill moment...I just did a quick google and found 'MVC Mini Profiler', will that do, or do you have a preferred Profiler? Thanks PP

Tuesday, March 22, 2016 6:09:55 AM bypigpen
  • pigpen
  • Lv. 02 Rookie
  • Total EXP: 58

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

The mini-profiler module for Orchard is by far the easiest to set-up. If you've never used a profiler before, it's also the easiest. It may or may not help you though as it's not quite as comprehensive as other profilers. But if the slowdown comes from SQL queries for example, which is extremely likely, it'll show you that.

Tuesday, March 22, 2016 6:50:48 AM bybleroy
  • bleroy
  • Lv. 08 Rookie
  • Total EXP: 527

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

First of all, thanks for all of the above :) and I was just wondering if you wouldnt mind taking a quick look at the following image; the very first capture:

https://i.imagestash.io/nWw3mKEMqz.jpg

Looks pretty scary - so am I to assume that anything above 10ms is getting resource hoggish? And are duplicate queries always a bad thing [as they appear in standard Orchard Modules - but I maybe reading it wrong; still quite confused]? And is it basically saying that sql queries only make up 1% of the 32s - so I have issues elsewhere? Thanks again for your input and time thus far, very much appreciated, PP

Wednesday, March 23, 2016 10:24:32 AM bypigpen
  • pigpen
  • Lv. 02 Rookie
  • Total EXP: 58

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

You definitely have issues elsewhere, but your SQL is not fast either. I'd look at both the specific queries (pass them through the query analyzer), and at some of those shapes. I mean, two seconds to display social links? That's insane.

Wednesday, March 23, 2016 4:22:37 PM bybleroy
  • bleroy
  • Lv. 08 Rookie
  • Total EXP: 527

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

Thanks a lot bleroy...ha, insane indeed - it appears a rewrite of mine may've been the largest culprit for such huge delays. I reorganized my rewrite rules and got rid of a IsDirectory clause that seemed to reduce the times substantially; however, when it comes to a simple contact form the load time still seems slow?

https://i.imagestash.io/mnwRdJ7MQZ.jpg

...as the form was created purely by Orchard components via the admin gui without any customization from myself - is this to be expected as normal? Thanks again, PP

Thursday, March 24, 2016 1:40:49 AM bypigpen
  • pigpen
  • Lv. 02 Rookie
  • Total EXP: 58

Re: 1.10 Very Poor Performance with Local / Live - huge wait times?

No, it's not expected. Seems like you need to dig deeper, with maybe dotTrace or something similar.

Thursday, March 24, 2016 2:40:11 AM bybleroy
  • bleroy
  • Lv. 08 Rookie
  • Total EXP: 527

Post a reply

You need to be signed in to post a reply.

Sign In