Yeah. it seems to connect just fine, though my sensation is, that it is not as fast as it could be. What really breaks it is this stupid little query above.
2009/4/21 Keith Bloom <[email protected]> > > Hello, > > Does your application get a connection to the database at all? > > You can use NHProf http://nhprof.com/ to examine what is happening > when the timeout occurs. > > Keith. > > 2009/4/21 Jan Limpens <[email protected]>: > > hello, > > > > on the production server (where else), my otherwise snappy web app > suddenly > > has timeouts and crawls like a snail. > > > > my config is: > > <settings> > > <item key="show_sql">true</item> > > <item key="max_fetch_depth">1</item> > > <item > > key="dialect">NHibernate.Dialect.MsSql2005Dialect</item> > > <item > > > key="connection.provider">NHibernate.Connection.DriverConnectionProvider</item> > > <item > > key="connection.driver_class">NHibernate.Driver.SqlClientDriver</item> > > <item key="connection.connection_string">Data > > Source=.\SQLEXPRESS;Initial Catalog=dbname;Integrated > Security=True</item> > > <item key="connection.isolation">ReadCommitted</item> > > <item key="default_schema">dbname.dbo</item> > > <item key="query.substitutions">true 1, false 0, yes > > 'Y', no 'N'</item> > > <item key="adonet.batch_size">10</item> > > <item > > > key="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, > > NHibernate.ByteCode.Castle</item> > > </settings> > > > > on the same server, different database, with the almost identical > > connectionstring, I get good results, too. but here... > > > > System.Data.SqlClient.SqlException: Timeout expired. The timeout period > > elapsed prior to completion of the operation or the server is not > > responding. > > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, > > Boolean breakConnection) > > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > > exception, Boolean breakConnection) > > at > > > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject > > stateObj) > > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, > > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet > > bulkCopyHandler, TdsParserStateObject stateObj) > > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > > at System.Data.SqlClient.SqlDataReader.get_MetaData() > > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader > ds, > > RunBehavior runBehavior, String resetOptionsString) > > at > System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean > async) > > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String > method, > > DbAsyncResult result) > > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String > method) > > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior > > behavior, String method) > > at > System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior > > behavior) > > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > > at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) > > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean > > autoDiscoverTypes, Boolean callable, RowSelection selection, > > ISessionImplementor session) > > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, > > QueryParameters queryParameters, Boolean returnProxies) > > at > > > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor > > session, QueryParameters queryParameters, Boolean returnProxies) > > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, > > QueryParameters queryParameters) > > > > anyone could give me hints where to look? > > you know, it works on my machine ;) (duck). > > > > thanks! > > > > -- > > Jan > > > > > > > > > > > -- Jan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
