Activities of "liaquathussain"

Hi,

Sorry for late reply, I was away.

Following is access detail.

https://app.speedautosystems.com Company Code (Tenant Code): BelhasaTest Username: admin Password: admin123

DB is already tunned properly, infact it is auto tunned by Azure and indexes are created reqularly, DB response and queries running is fine if excute some query directly.

Question is, why app gone slow after upgrade.

Before upgrade we were using following plan for azure Azure Web App 1 Large Intance Azure DB Standard (S3) 100 DTU Utilization and app response was ok

After upgrade we have to increase resources as app was totally stuck Azure Web App 2 Large instances Azure DB Standard (S4) 200 DTU Even doubling resources, app response is considerable slow than previous one. Earlier we were not having any complaints from our customers now we do have frequent complains

Also breaking abp/aspzero related data loading to module basis is very important as it works following.

"On startup, as dynamic web api is created, js proxies are generated, all permissions and localization data is loaded, all js files are bundled and loaded once,"

Is there any way to

1. instead of dynamic web api generation we can have while building solution to avoid runtime time consumption?
2. Is there any way to break permissions and localization data to modules and for specific module only that part should be loaded?
3. Is there any way to generate js proxies based on group of app services so that only module specific js should be created?

You valuable suggestion will help us to get it fined tunned as our app is growing day by day, features are increasing, tenants are increasing.

Thanks you!

Hi,

We used ASPZero template “ASP.NET MVC 5.x & Angularjs 1.x” to build SPA (single page application) multitenant, multilingual business app having multiple modules. Initially it worked great but with the passage of time it is going slow day by day as we are adding more modules/feature to this app.

Earlier we started this app from 0.8.x version of aspzero, app was somewhat ok. Recently we migrated to aspzero version 5.x. after this we have noticed reasonable degrade in performance and 2 to 3 times more resource hungry.

Following is the glimpse of our app • No of Application Services: 200+ • No of Database Entities: 160+ • No of Features: 200+ • No of Permissions: 550+ • No of Key/Value pairs in localization file (xml): 2950+ • No of Angular js controllers and corresponding csthmls: 600+

As a consequence… • On startup, as dynamic web api is created, js proxies are generated, all permissions and localization data is loaded, all js files are bundled and loaded once, so all this badly decreasing loading time • DB entities are increasing and DB operations are getting slower • So it is not only going slow but also becoming much compute-resource hungry

We want to break app to multiple modules where only specific data and things should be loaded as per required by any module. Please provide your suggestions regarding this how we can optimize app and increase performance to optimum level with reasonable compute resources

App URL: app.speedautosystems.com

Thanks & Regards,

Thanks cangunaydin your solution is working

Basically, we are developing a multitenant application using ABP zero and at this point when we have several features already developed. Some clients/countries/region has different requirements than others and we want to have some flexibility in our application to encompass these minor UI or Business logic differences. I am aware of the awesome out of the box features like localization, and edition management, i just want to wire things up a bit for the sake of clarity for example, There are differences in the operational procedures in different countries and some clients like to have their own brand theme for UI. so how does the framework recommends to encompass these data model/Business logic/and UI differences in our applicaiton do we have to have separarate Views for every single Tenant for UI difference or it has a something out of the box to deal with Themes just like nopcommerce for exmple? should we develop separate ApplicationServices and Domain services in that case?

i am basically intersted to have a some changes (in UI, Business logic and Additional Fields) to be treated as a unit just like in the case of a plugin

if i choose to create my own repository implementation where would i register the Context Dependency and where should the context be kept in EntityFramework project or Some other project?

yes i have a 2nd db context and as I have already mentioned that I am using a third party database so, I am unable to go with Code first approch. even if I choose to go with code first somehow(i know Its not suitable in this scenario). I would have to face same problem

I would not be able to use Repositories as it requires IEntity Interface to be implemented and IEntity has an Id property to be used as primary key. which cannot be ensured that other database must be using a column with name Id as primary key.

here is an example of entities from other dbContext

public partial class Location { public string Code { get; set; } // primary key in this case public string Description { get; set; } public decimal StSpotAgmtNo { get; set; } ... }

thank you Windows Azure does not support MSDTC yet. any workaround for that ?

when we try to use a DbContext directly to save some records it throws following exception on calling savechanges()

►System.Data.Entity.Core.EntityException {"The underlying provider failed on Open."} ►inner exception TransactionManagerCommunicationException {"Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool."} ►Inner Exception COMException {"The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)"}

I understand that normally we should avoid directly using dbContexts in AppService and use repositories but in my case I have to integrate my app with a third-party database application and for this I am using DB first approach to create that model.
please give me some direction how to handle this scenario. it's urgent.

we are developing an application using this architecture but having difficulties in adding third party databases with db first approach

if we add an Entity Data model it simply generates the entities that belong to other database. now we need to be able to create repositories of these third party entities.

Now problem is when we try to resolve IRepository<ThridPartyEntity>, it complains that ThridPartyEntity must apply abps IEntity interface. please suggest a solution for this.