Activities of "maharatha"

Hi -

I have been struggling with performance issue with my code. I am using New Relic to find out what's the issue but it hasn't helped much.

Below is a brief description of my issue :

I have written a method called : GetVendorUnits(SearchInputDto input) which is being exposed as a Web Api. When I monitor in Audit Log or using New Relic I am observing it's executing within 1100 mili seconds, but the response I get back from the server is taking 12 - 15 seconds and sometime more.

[attachment=0:oa152h8v]Relic.png[/attachment:oa152h8v]

Could you please point me to the right direction to troubleshoot the issue on where the time is being spent and what to look for ?

Few questions :

1. Why is the constructor being called so many times ?
2. Where are the areas I should look into ?

I am having no clue how to figure this out.

Note :

1. If you look at the time spent in constructor is minimal but the code that's getting executed withing each constructor access is causing the delay.

2. I am directly calling the GetVendor web service and no other processing is being done.

I am literally stuck and unable to move forward.

Any help will be highly appreciated.

Thanks, Partha

Hi -

I am using New Relic to monitor my performance.

Most of my time is being spent on : Application code (in ExecuteRequestHandler) .

Where as the internal methods is taking few milli seconds.

I am unable to trace the Application Code.

What could be the application code which could be slowing me down ? Any idea ?

I am trying to access the google API from the client side and below is the error I am getting :

XMLHttpRequest cannot load <a class="postlink" href="http://maps.googleapis.com/maps/api/geocode/json?address=4566">http://maps.googleapis.com/maps/api/geo ... dress=4566</a>. Request header field X-XSRF-TOKEN is not allowed by Access-Control-Allow-Headers in preflight response.

Please advise.

Hi -

This question if more towards entityframework rather than AspnetZero, but I would like see if i can get some answers.

I have basically 4 tables , let's say A, B, C & D.

C inherits A -- C:A D inherits B -- D:B

A is the header table and B is the detail tables. So there is a foreign key relationship between A & B

var query2 = D.GetAll()
                .Include(p => p.B)
                .Include(p => p.A)
               .Include (p =>p.C)

I am able to access all properties of B & A but unable to access properties of C.

Any help would be appreciated

Should I use Index on TenantID and IsDeleted column as we use it in every query

Hi All -

I am facing some serious slowness when Entityframework loads the data for the first time.

Any idea to make the initial load faster ?

Secondly I would like to use views , so would like to create a view using code first approach. Could you provide some guidance

Thanks, Partha

Hi -

I have been trying to set the virtual absolute path and security in my startup.cs like the below :

app.UseHangfireDashboard("/BackgroundJobs", new DashboardOptions
            {
                Authorization = new[] { new AbpHangfireAuthorizationFilter(AppPermissions.Pages_Administration_Host_Hangfire) }
            });

            app.UseHangfireDashboard("/BackgroundJobs", new DashboardOptions
            {
                AppPath = VirtualPathUtility.ToAbsolute("~/Application/App")
            }
            );

The authorization works but the App path doesn't work. It always redirect to the root URL where as I am trying the user to redirect to the dashboard.

Am I doing it right ?

how do I access the DB Context from application layer ?

I am trying to run code similar to below in application Layer :

using (var ctx = new TestContext()) { ctx.AuditEntries.Where(item); ctx.AuditEntries.Where<Entity_Basic>(item.ID); ctx.AuditEntries.Where<Entity_Basic>(101); }

Can you point me to the right direction ?

Hi -

Is there a way I can check the referential integrity while deleting items ? e.g. I want to restrict Tenants to be deleted if any transaction or user is associated with that Tenant.

How do i do it ?

Hi All -

This is to get some guidance about building a notes and attachment infrastructure in my application using Abpzero.

My requirement is I should be able to add Multiple Notes or Multiple Attachments to any row in any entity.

I am looking for something like IMayHaveNotes or ImayHaveAttachments. But I am probably not able to get my head around it about the approach.

Any help is appreciated?