开发者

Enterprise Library 5.0 - DatabaseFactory.CreateDatabase() - Slow performance

开发者 https://www.devze.com 2023-03-14 16:55 出处:网络
Im using Enterprise Library 5.0 Data Access block. the Creation of a databaseinstance is really slow. DatabaseFactory.CreateDatabase() statement consumes a lot of time when connecting to SQL Server

Im using Enterprise Library 5.0 Data Access block. the Creation of a databaseinstance is really slow. DatabaseFactory.CreateDatabase() statement consumes a lot of time when connecting to SQL Server

  1. What are the best practices for high performance Enterprise library DAAB DB creation
  2. Can I Create a object pooling mechanism and reuse the Objects开发者_JAVA百科 rather than creating it again and again. Will this create any concurrency problems?


DatabaseFactory.CreateDatabase doesn't connect to the database server at all; if it's slow, something else is going on. The only external thing it should be hitting is the configuration file, and that should only happen on the first request.

Where is your configuration (disk? network share? database? other?)?

Also - how do you define "really slow"? Can you post a sample that demonstrates the problem?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号