GetScripts extremely slow #410

rahulbpatel created 9 years ago

I'm having the same problem as described in aspnetboilerplate issue #466 that was closed with module-zero issue #101. I am currently using Abp.Zero v 0.7.0.0 which should include that fix. However, it always takes > 10 seconds to load this script which is painful for development:

<a class="postlink" href="http://screencast.com/t/o3rRbNYPl">http://screencast.com/t/o3rRbNYPl</a>

I fired up SQL Profiler and browsing directly to ~/AbpScripts/GetScripts?v=635802848105548951 in my environment results in 1130 queries being executed. A lot of them just look like this:

exec sp_executesql N'SELECT TOP (1) 
    [Extent1].[Id] AS [Id], 
    [Extent1].[TenantId] AS [TenantId], 
    [Extent1].[Name] AS [Name], 
    [Extent1].[DisplayName] AS [DisplayName], 
    [Extent1].[IsStatic] AS [IsStatic], 
    [Extent1].[IsDefault] AS [IsDefault], 
    [Extent1].[IsDeleted] AS [IsDeleted], 
    [Extent1].[DeleterUserId] AS [DeleterUserId], 
    [Extent1].[DeletionTime] AS [DeletionTime], 
    [Extent1].[LastModificationTime] AS [LastModificationTime], 
    [Extent1].[LastModifierUserId] AS [LastModifierUserId], 
    [Extent1].[CreationTime] AS [CreationTime], 
    [Extent1].[CreatorUserId] AS [CreatorUserId]
    FROM [dbo].[AbpRoles] AS [Extent1]
    WHERE ((([Extent1].[TenantId] IS NULL) AND (@DynamicFilterParam_3 IS NULL)) OR (([Extent1].[TenantId] IS NOT NULL) AND ([Extent1].[TenantId] = @DynamicFilterParam_3)) OR (@DynamicFilterParam_4 IS NOT NULL)) AND (([Extent1].[IsDeleted] = @DynamicFilterParam_1) OR (@DynamicFilterParam_2 IS NOT NULL)) AND ([Extent1].[Name] = @p__linq__0)',N'@DynamicFilterParam_3 int,@DynamicFilterParam_4 bit,@DynamicFilterParam_1 bit,@DynamicFilterParam_2 bit,@p__linq__0 nvarchar(4000)',@DynamicFilterParam_3=1,@DynamicFilterParam_4=NULL,@DynamicFilterParam_1=0,@DynamicFilterParam_2=NULL,@p__linq__0=N'InventoryTracker'

Since the issue has been resolved what are some places for me to look into why this is happening for me?

2 Answer(s)