chadwixk wrote:Ah, no that was for a VM only where you can create a network security group, not with web apps....will have to investigate further.
Yes! Have that Chinese visitor as well. Can maybe set up a firewall rule to block Chinese IP addresses in Azure?
I'm thinking about trying
ModSecurity, does anyone have an opinion on ModSecurity? I'm surprised Azure web apps doesn't have a built in Firewall solution.
Nop-Templates.com wrote:Hi guys,
because I'm seeing that our plugin ( Ajax Filters ) is mentioned quite a few times, I would like to clear the thing up with it.
When a URL with "?specs=220,715,700" in it, is loaded, nopCommerce is using its own stored procedure ( from which the mentioned slow query is ) to load the products. Our plugin does not call its own stored procedure until any filtering is applied by the customers ( calling "?specs=***" would not trigger anything in our plugin ). Also, when you filter with the Ajax Filters plugin, we are appending the applied filters after the hashtag symbol ( computers#/specFilters=2m!#-!6, for example ), which is only client-side ( only on customer's machine ) and it cannot be indexed by the search engines.
Keep in mind that if you really have a search engine, which is refreshing your site a few times in a second, then it is normal that you have 100% DTU usage. In the end, requesting this slow query so frequently is really "expensive" and this is keeping the DTU usage at maximum levels. My suggestion is to blacklist those Chinese IPs, which the "search engine" is using.
Hope this helps!
Regards,
Hristian
Thank you Hristian for clarifying. I agree, It's not a Nop-Templates issue, but an issue with a bot stuck on a Nopcommerce long running query. In my case that bot is a Chinese bot, whereas Lintho's bot is from Google. Thank you for the suggestion.