Activities of "sparkyjr"

I host my site on Azure. Also I have not tried to add MIME types on IIS.

Thanks a lot for your solution!

<cite>drcgreece: </cite> Are you getting this error with a specific file or all of them? I faced same problem it was something related to bundling.

I am getting for 4-5 files , the name are all encrypted on the server but the errors appear on all the pages. Could you please share your bundling solution.

I am getting .woff (500 Internal server error) when my website is hosted on the server. I have tried adding the following line to the web config. <staticContent> <remove fileExtension=".woff" /> <remove fileExtension=".woff2" /> <mimeMap fileExtension=".woff" mimeType="application/font-woff" /> <mimeMap fileExtension=".woff2" mimeType="application/font-woff2" /> </staticContent>

Also I have tried some help from the internet , but it did not help.

Thanks alirizaadiyahsi for your reply!

The Custom Repository has to be extended from either IRepository<TEntity> or IRepository<TEntity, TPrimaryKey>, am I right? What is TEntity in my case? Because Stored Proc doesn't depend on any specific Entity or SQL table. It will play with multiple SQL tables and return a result-set(s). How do I achieve this? Or am I missing something?

Also, please send me your example for calling the Stored Proc from a Custom Repository. That may help!

Regards, SparkyJr

Hi ismcagdas,

Thanks for your reply!

I tried to understand from the documentation link you had in your reply. But, I do not want to add a repository for an entity. I want to call a SQL Stored Proc and UDF from App Service. The Stored Proc is not specific to a single entity or a SQL table.

It would be great if you could provide me a good example which shows how exactly you call a SQL Stored Proc and UDF from App Service.

Regards, SparkyJr

Thanks for the reply.

<ins>The web app service details are</ins> Standard: 1 Small tier Location: West US Single instance Always On: Enabled Web Sockets: Enabled All other properties are default

<ins>The database details are:</ins> Pricing Tier: Standard: S0 Location: West US No replication or anything like that Have build index automated

I did see a small improvement when we precompiled the views and did a single DLL deployment (based on blog [http://blog.deltacode.be/2017/01/08/fix-slow-startup-of-asp-net-mvc-5-on-azure-app-services/])), but it wasn't very significant.

Other information...

I have been using the background job of ASPNetZero recently to send emails. I don't expect it to be a resource hog, and on the local machine it does not seem to have any impact.

I am getting the SocketExceptions show up in logs in Azure, but not on local machine. But since that needs an update, I've postponed doing it until I get some breathing time. [https://forum.aspnetboilerplate.com/viewtopic.php?f=5&t=5254&p=12762&hilit=audit+info+azure#p12762])

The perf drop seem to be more impacted if the site is idled for a while, maybe even 20 mins of non activity makes it feel like it has to load all over again. I did set the AlwaysOn option enabled in Azure, so can't think of what might be the reason.

Glimpse and Network Analyzer always seems to show that the system calls the Controller and then wait forever to get the data following. The css and js scripts are downloaded quickly, which makes me think it is not a network latency issue.

Hi,

I need to call a SQL stored proc from an app service. For that I will need access to the DBContext. I don't think I can access it directly from Application project.

What is the correct way to call a SQL stored proc and UDF from an app service?

Thanks, SparkyJr

We've had our production service on Azure. Locally, our aspnetzero application runs pretty fast (always < 4 sec PLT) but on Azure, we are seeing extremely long load times. Some pages take over a minute to load, with typical page load times in 30 - 40 sec range. Often it seems the initial controller call seems to be taking the most time with Glimpse stating that the Action of the Controller taking the most time. It also does not appear to be a cold boot issue, since even after setting AlwaysOn = true, we see the pages become slow if now accessed after a while.

The exact same database and configuration loaded on a local or network box is many times faster. Is there something specific to Azure that inhibits Asp.NET Zero application performance? Perf profiling did not seem to show any obvious issues.

Has anyone faced these problems before? Any help on why it is working incorrectly only on Azure?

Thanks ismcagdas for your reply!

I will try to answer some of your questions:

<cite>ismcagdas: </cite> Can you give a number for >these application services has many items injected . We will try to create the same scenario.

We have 20 repositories and 15 application services injected in a constructor of one of the application service. Let me give you an example to make it clear:

I have 3 application services, say, A, B and C. Here, constructor of C has 25 items (20 repositories and 5 application services) injected in its constructor constructor of B has 35 items (25 repositories and 10 application services - one of them is C) injected in its constructor constructor of A has 35 items (20 repositories and 15 application services - two of them are B and C) injected in its constructor

<cite>ismcagdas: </cite> Is there any time consuming operation in one of the injected class's constructor ? Maybe you have missed one becasue there are many injected class, is it possible ?

So, the constructor of C is being initialized 3 times (well, 5 times in real case). This cascading effect is causing the problem. At least, that is what I think.

Any suggestions?

Thanks, SparkyJr