DevForce Community Forum : Speed up initialization http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : Speed up initialization Fri, 10 Apr 2026 20:58:19 -700 Tue, 30 Apr 2013 18:44:25 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4097 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Speed up initialization : We've made some changes to... http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16276#16276 Author: kimj
Subject: 4097
Posted: 30-Apr-2013 at 6:44pm

We've made some changes to ibmmx loading in the 7.1.2 release. Let us know if you see any performance improvement.]]> Tue, 30 Apr 2013 18:44:25 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16276#16276 Speed up initialization : I do understand that, that is... http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16185#16185 Author: KitKat
Subject: 4097
Posted: 05-Apr-2013 at 4:51am

I do understand that, that is still an 18% improvement.]]> Fri, 05 Apr 2013 04:51:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16185#16185 Speed up initialization : I think we still have the ibmmx... http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16179#16179 Author: kimj
Subject: 4097
Posted: 04-Apr-2013 at 2:22pm

I think we still have the ibmmx and model project from your problem with the RelatedEntityList a few weeks ago. We'll try running some tests with that. Remember, though, that in the (unlikely) event we make this super fast, it still accounts for only 4 seconds out of 22.]]> Thu, 04 Apr 2013 14:22:42 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16179#16179 Speed up initialization : Would a Copy of our ibmmx or Model... http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16178#16178 Author: KitKat
Subject: 4097
Posted: 04-Apr-2013 at 1:30pm

Would a Copy of our ibmmx or Model Project help your investigation? We have the model split into its own dedicated assembly with nothing else in it.]]> Thu, 04 Apr 2013 13:30:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16178#16178 Speed up initialization : Here's what I see going on... http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16177#16177 Author: kimj
Subject: 4097
Posted: 04-Apr-2013 at 11:43am

Here's what I see going on here:

- Between 12:10:41 and 12:10:44 it's not clear what's happening, presumably IIS Express startup.

- Probing starts at 12:10:44 and completes at 12:10:45. Modifying the search patterns would probably not help much, but you can set the CompositionHost.SearchPatterns and/or IgnorePatterns in the static constructor of your Cocktail bootstrapper. See Cocktail documentation for more information.

- DevForce services are started between 12:10:45 and 12:10:47.

- Login is at 12:10:48

- 12:10:51 - The first query is received, which triggers ibmmx load.

- 12:10:51 - 12:10:55 - ibmmx load

- 12:10:55 - 12:11:02 - The DbContext is created.

So I see two performance hot spots: 1) the ibmmx takes 4 seconds to load, and 2) DbContext initialization takes 7 seconds.

During ibmmx load DevForce will initialize the EntityMetadataStore and other metadata. This is generally not a fast process, but four seconds does seem slow, so we can investigate further to see if this can be reduced.

If you're already using pre-generated views, you probably won't be able to reduce the DbContext init time further without splitting your model into smaller components, although based on web searches it seems that EF has performance issues with even small DbContext-based models, so I don't know what to recommend here.

The "good" news is that all this server initialization does occur once only on a cold start. When your application is deployed to IIS you can modify application pool settings to reduce recycling or try some sort of scheduled batch job to keep the services alive and avoid performance hits visible to your users.







]]> Thu, 04 Apr 2013 11:43:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16177#16177 Speed up initialization : How can we speed up the initialization... http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16174#16174 Author: KitKat
Subject: 4097
Posted: 04-Apr-2013 at 9:14am

How can we speed up the initialization of the database, even with PreCompiled Views, the first access take about 22-25 seconds.  Below is a debug log of the initialization.  Also, where in a DevForce/Cocktail Application can I modify the Discovery Search Patters.  Anywhere I put it either has no effect or causes an exception.

Thank you,
Katerina

0 : 4/4/2013 12:10:41 PM :  : IdeaBlade.Core.IdeaBladeConfig:Initialize : Initializing configuration ...
1 : 4/4/2013 12:10:44 PM :  : IdeaBlade.Core.Composition.PartsCatalog:LoadCatalog : MEF assembly probing started: 4/4/2013 12:10:44 PM.  If this takes a long time, use IdeaBlade.Core.Composition.CompositionHost to specify/restrict which assemblies to probe.
2 : 4/4/2013 12:10:45 PM :  : IdeaBlade.Core.Composition.PartsCatalog:LoadCatalog : Assembly 'LightworkDb.Web, Version=1.0.0.147, Culture=neutral, PublicKeyToken=93fdd07a360417b6' added to PartsCatalog
3 : 4/4/2013 12:10:45 PM :  : IdeaBlade.Core.Composition.PartsCatalog:LoadCatalog : MEF assembly probing completed: 4/4/2013 12:10:45 PM
4 : 4/4/2013 12:10:45 PM :  : IdeaBlade.Core.Composition.CompositionHost:.ctor : Probe Assemblies: Caliburn.Micro, Version=1.4.0.0, Culture=neutral, PublicKeyToken=8e5891231f2ed21f :: Cocktail.Utils, Version=2.2.0.0, Culture=neutral, PublicKeyToken=7d8c7326b555a04a :: LightWork.Web, Version=1.0.0.11, Culture=neutral, PublicKeyToken=93fdd07a360417b6 :: LightworkDb.Web, Version=1.0.0.147, Culture=neutral, PublicKeyToken=93fdd07a360417b6 :: LogicNP.CryptoLicensing, Version=9.0.0.0, Culture=neutral, PublicKeyToken=4a3c0a4c668b48b4 :: LwResources, Version=1.0.0.3, Culture=neutral, PublicKeyToken=93fdd07a360417b6 :: PerrymanSoftware.INIFiles, Version=1.0.0.0, Culture=neutral, PublicKeyToken=93fdd07a360417b6  If this list is unnecessarily large, use CompositionHost.SearchPatterns to modify the search critieria for probed assemblies. If this list does not contain the assembly(ies) holding your a) domain model, b) custom interface implementations, and c) POCO/known types then your application may not work correctly. Ensure that these assemblies are available in the exe/bin folder, and if using CompositionHost.SearchPatterns that the patterns are set appropriately.
5 : 4/4/2013 12:10:45 PM :  : IdeaBlade.Core.IdeaBladeConfig:InitializationStatusCallback : IdeaBlade License: 'Silverlight', KeyDate: 11/2/2012, AllowedSessions: 10000. Found on Assembly: 'LightworkDb.Web, Version=1.0.0.147, Culture=neutral, PublicKeyToken=93fdd07a360417b6'
6 : 4/4/2013 12:10:45 PM :  : IdeaBlade.Core.Configuration.ServerSettingsElement:ConstrainSettingsBasedOnLicenseCore : The configured SupportedClientApplicationType is Silverlight
7 : 4/4/2013 12:10:45 PM :  : IdeaBlade.Core.Configuration.ServerSettingsElement:ConstrainSettingsBasedOnLicenseCore : Session-agnostic load balancing is not supported with this license.
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Net.Http\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Net.Http.dll'
8 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for non-default 'ITraceLoggerProvider' and found no matching exports.
9 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for default 'ITraceLoggerProvider' and found 'IdeaBlade.Core.DefaultLoggerProvider'.
10 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.TraceFns:CompleteTracingInitialization : IdeaBladeConfig resolution: File: C:\Projects\LightWork\LightWork.Web\web.config - found
11 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.TraceFns:CompleteTracingInitialization : IdeaBladeConfig resolution: Logging file: 
12 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.TraceFns:CompleteTracingInitialization : Bound to .NET runtime version 4.0.30319.17929
13 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.TraceFns:CompleteTracingInitialization : DevForce version 7.0.3.0
14 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.RemoteServiceFns:AddSerializationBehavior : Using DC serializer for EntityService
15 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for any 'ServiceHostEvents' and found 'IdeaBlade.EntityModel.Server.ServiceHostEvents'.
16 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.Server.EntityServiceHostFactory:CreateServiceHost : EntityService listening on http://localhost:42620/EntityService.svc/sl
17 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for any 'EntityServiceApplication' and found 'IdeaBlade.EntityModel.EntityServiceApplication'.
18 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.EntityServiceApplication:OnServiceStartup : EntityService created
19 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.Server.EntityServer:.ctor : EntityServer created for DataSourceExtension: [None], CompositionContext: IbDefault
20 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for any 'ICompositionContextResolver' and found no matching exports.
21 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for default 'IDataSourceKeyResolver' and found 'IdeaBlade.EntityModel.DefaultDataSourceKeyResolver'.
22 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for any 'IEntityQueryExecutor' and found 'IdeaBlade.EntityModel.Edm.EdmQueryExecutor'.
23 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for any 'IEntityQueryExecutor' and found 'IdeaBlade.EntityModel.Edm.PassthruEsqlQueryExecutor'.
24 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for any 'IEntityQueryExecutor' and found 'IdeaBlade.EntityModel.Edm.StoredProcQueryExecutor'.
25 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for any 'IEntityQueryExecutor' and found 'IdeaBlade.EntityModel.Edm.UdtQueryExecutor'.
26 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.Server.SessionManager:GetLoginManager : Anonymous access: enabled
27 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for non-default 'IEntityLoginManager' and found no matching exports.
28 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.Server.SessionManager:GetLoginManager : Looking for AspAuthenticatingLoginManager
29 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.Web.AspAuthenticatingLoginManager:.ctor : ASP.NET security service integration enabled
30 : 4/4/2013 12:10:46 PM :  : IdeaBlade.EntityModel.Web.AspAuthenticatingLoginManager:.ctor : ASP.NET authentication mode: Forms
31 : 4/4/2013 12:10:46 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for default 'IEntityLoginManager' and found 'IdeaBlade.EntityModel.Web.AspAuthenticatingLoginManager'.
32 : 4/4/2013 12:10:47 PM :  : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for non-default 'IKnownTypeProvider' and found no matching exports.
33 : 4/4/2013 12:10:47 PM :  : IdeaBlade.EntityModel.RemoteServiceFns:AddSerializationBehavior : Using DC serializer for EntityServer
34 : 4/4/2013 12:10:47 PM :  : IdeaBlade.EntityModel.Server.EntityServerHostFactory:CreateServiceHost : EntityServer listening on http://localhost:42620/EntityServer.svc/sl
35 : 4/4/2013 12:10:48 PM :  : IdeaBlade.EntityModel.EntityServerProxy:GetInstance : Loaded IdeaBlade.EntityModel.LocalEntityServerProxy
'iexplore.exe' (Silverlight): Loaded 'C:\Program Files (x86)\Microsoft Silverlight\5.1.10411.0\en-US\System.Runtime.Serialization.debug.resources.dll'
The thread '<No Name>' (0x2ef8) has exited with code 0 (0x0).
The thread '<No Name>' (0x2a98) has exited with code 0 (0x0).
36 : 4/4/2013 12:10:51 PM : Guest - 1 : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for any 'EntityServerQueryInterceptor' and found 'IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor'.
The thread '<No Name>' (0x2eec) has exited with code 0 (0x0).
The thread '<No Name>' (0x1e04) has exited with code 0 (0x0).
37 : 4/4/2013 12:10:55 PM : Guest - 1 : IdeaBlade.EntityModel.EntityMetadataStore+<>c__DisplayClass13:<LoadMetadataFromEmbeddedResources>b__10 : Metadata file 'LightworkDb.Web.LightWorkDb.ibmmx' loaded from assembly 'LightworkDb.Web, Version=1.0.0.147, Culture=neutral, PublicKeyToken=93fdd07a360417b6' 
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.CSharp\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.CSharp.dll', Symbols loaded.
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll', Symbols loaded.
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll'
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data.OracleClient\v4.0_4.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll'
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Dynamic\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Dynamic.dll'
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll'
38 : 4/4/2013 12:10:55 PM : Guest - 1 : IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor:ExecuteQuery : Fetch ... value(IdeaBlade.EntityModel.EntityQueryProxy`1[LightworkDb.Web.Entities.General.LwCiTheme]).Where(t => t.DefaultLightWorkTheme)
39 : 4/4/2013 12:10:55 PM : Guest - 1 : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for non-default 'IDataSourceKeyResolver' and found no matching exports.
40 : 4/4/2013 12:10:55 PM : Guest - 1 : IdeaBlade.EntityModel.Edm.DbKey:Initialize : Initializing DbKey for LightWorkDb, connectionString = 'Server=PAI-SRV-SQL2.perryman.local;Database=LightworkDb;User Id=sa;Password=P@ssW0rd'
41 : 4/4/2013 12:10:55 PM : Guest - 1 : IdeaBlade.EntityModel.Edm.DbKey:FindSubTypedDbContext : DBKey 'LightWorkDb': Found DbContext 'LightworkDb.Web.Context.LightWorkDb'
42 : 4/4/2013 12:10:55 PM : Guest - 1 : IdeaBlade.EntityModel.Edm.DbKey:FindModelAssembly : DataSourceKey: 'LightWorkDb' found in assembly 'LightworkDb.Web, Version=1.0.0.147, Culture=neutral, PublicKeyToken=93fdd07a360417b6' at 4/4/2013 12:10:55 PM
The thread '<No Name>' (0x11b4) has exited with code 0 (0x0).
The thread '<No Name>' (0x2020) has exited with code 0 (0x0).
43 : 4/4/2013 12:11:02 PM : Guest - 1 : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for any 'IIdGenerator' and found 'IdeaBlade.EntityModel.StoreGeneratedIdGenerator'.
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'EntityFrameworkDynamicProxies-LightworkDb.Web'
44 : 4/4/2013 12:11:02 PM : Guest - 1 : IdeaBlade.Core.Composition.CompositionHost:CheckMultiExport : CompositionContext: 'IbDefault' - Probed for non-default 'IConcurrencyStrategy' and found no matching exports.
45 : 4/4/2013 12:11:02 PM : Guest - 1 : IdeaBlade.Core.Composition.CompositionHost:CheckSingleExport : CompositionContext: 'IbDefault' - Probed for default 'IConcurrencyStrategy' and found 'IdeaBlade.EntityModel.DefaultConcurrencyValueSetter'.
46 : 4/4/2013 12:11:02 PM : Guest - 1 : IdeaBlade.EntityModel.Edm.EdmMetadataHelper:DiscoverEdmEntities : Loading EDM metadata for LightWorkDb
]]> Thu, 04 Apr 2013 09:14:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4097&PID=16174#16174