Is there a limit on the number of items or categories?

Question

After loading my products via XML import I get the follow error after tring to access the web site.  I've isolated the possibility of data issues and I'm sure it is related to the number of records loaded.  Attached is the error from the event log:

Event Type: Error
Event Source: SharePoint Commerce Services Exceptions
Event Category: None
Event ID: 0
Date:  11/7/2009
Time:  7:45:59 PM
User:  N/A
Computer: WEB
Description:
An exception of type 'System.Threading.ThreadAbortException' occurred and was caught.
-------------------------------------------------------------------------------------
11/07/2009 19:45:59
Type : System.Threading.ThreadAbortException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Thread was being aborted.
Source : System.Data
Help link :
ExceptionState : System.Web.HttpApplication+CancelModuleException
Data : System.Collections.ListDictionaryInternal
TargetSite : IntPtr SNIPacketGetConnection(IntPtr)
Stack Trace :    at SNINativeMethodWrapper.SNIPacketGetConnection(IntPtr packet)
   at System.Data.SqlClient.TdsParserStateObject.ProcessSniPacket(IntPtr packet, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   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(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, CatalogDataSetType catalogDataSetType, SqlParameter[] commandParameters, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(ExecutionContext executionContext, String spName, Object[] parameterValues, CatalogDataSetType catalogDataSetType, String outParameterName, Object& outParameterValue)
   at Microsoft.CommerceServer.Catalog.Internal.SqlHelper.ExecuteDataset(ExecutionContext executionContext, String spName, CatalogDataSetType catalogDataSetType, Object[] parameterValues)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogCache.GetDataset(ExecutionContext executionContext, CacheItemType cacheItemType, String storedProcedureName, CatalogDataSetType catalogDataSetType, Boolean getFromCache, Object[] parameters, String outParameterName, Object& recordCount, Boolean& obtainedFromCache)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogCache.GetDataset(ExecutionContext executionContext, CacheItemType cacheItemType, String storedProcedureName, CatalogDataSetType catalogDataSetType, Boolean getFromCache, Object[] parameters, Boolean& obtainedFromCache)
   at Microsoft.CommerceServer.Catalog.Internal.Category.GetCategoryProperties(CatalogExecutionContext context, String baseCatalogName, String catalogName, Int32 oid, String language, Boolean getFromCache, Boolean isVirtualCatalog)
   at Microsoft.CommerceServer.Catalog.Internal.Category.PreLoadCategory(CatalogExecutionContext context, Category category, CategoryConfiguration config, Boolean getFromCache, Boolean relationshipsExist)
   at Microsoft.CommerceServer.Catalog.Internal.Category.GetCategoryData(CatalogExecutionContext catalogExecutionContext, String catalogName, String categoryName, String language, Nullable`1 isVC, Nullable`1 validateLanguage, CategoryConfiguration config, Boolean getFromCache)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config, Boolean getFromCache, Nullable`1 isVirtualCatalog, Nullable`1 validateLanguage)
   at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config)
   at Microsoft.CommerceServer.Catalog.Category.Get(CatalogContext catalogContext, String catalogName, String categoryName, String language, CategoryConfiguration config, Nullable`1 isVirtualCatalog, Nullable`1 validateLanguage)
   at Microsoft.CommerceServer.Catalog.Category.Get(CatalogContext catalogContext, String catalogName, String categoryName, String language, CategoryConfiguration config)
   at Microsoft.CommerceServer.Catalog.CatalogContext.GetCategory(String catalogName, String categoryName, String language, CategoryConfiguration config)
   at Microsoft.Commerce.Providers.CSHelpers.CatalogHelper.GetCategory(String siteName, String catalogName, String locale, String categoryName, CategoryConfiguration categoryConfiguration)
   at Microsoft.Commerce.Providers.Components.CategoryLoader.ExecuteQuery(CommerceQueryOperation queryOperation, OperationCacheDictionary operationCache, CommerceQueryOperationResponse response)
   at Microsoft.Commerce.Providers.Components.OperationSequenceComponent.Execute(CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)
   at Microsoft.Commerce.Broker.OperationSequence.ExecuteComponentTree(List`1 executionTreeList, CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)
   at Microsoft.Commerce.Broker.OperationSequence.ExecuteComponentTree(List`1 executionTreeList, CommerceOperation operation, OperationCacheDictionary operationCache, CommerceOperationResponse response)
   at Microsoft.Commerce.Broker.OperationSequence.Execute(CommerceOperation operation)
   at Microsoft.Commerce.Broker.MessageHandler.ProcessMessage(String messageHandlerName, CommerceOperation operation)
   at Microsoft.Commerce.Broker.OperationService.InternalProcessRequest(CommerceRequest request)
   at Microsoft.Commerce.Broker.OperationService.ProcessRequest(CommerceRequest request)

Additional Info:

MachineName : WEB
TimeStamp : 11/8/2009 1:45:59 AM
FullName : Microsoft.Commerce.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
AppDomainName : /LM/W3SVC/869253099/Root-1-129021175427962012
ThreadIdentity :
WindowsIdentity : MIKEKELLEYCONSU\csRunTimeUser

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Answer 1

FYI....

I found out what the issue was.  Since my catalog has about 25k items and 10k categories, Sharepoint services was timing out when starting the web site for the first time after a reboot.  I corrected the issue by modifing the Web.Config file and set the <System.web><compilation batchTimeout="600">.  Are there anymore timeout settings that should be set, like SQL connections etc?

Regards,
Mike