更新数据到数据库时失败：查询过于复杂

jeman

更新数据到数据库时失败：查询过于复杂。Int32 ExecuteCommandTextForSingleResult(System.Data.OleDb.tagDBPARAMS, System.Object ByRef)
部份页出现上面错误信息，不知道怎么回事，好像分页在100页以上，就会出现上面错误信息？

只有一个字段，就是读取每个分类下面的产品信息，表格形式，然后这些表格又是多页的，√该标签循环匹配 √该标签在分页中匹配 然后拼接分页内容，难道跟内容信息多有关？

303718

这种估计得收费版的MYSQL数据库才行

Deadwalkings

100页以上。。你采集的好多啊

jeman

数据量是很多，有1916944多个产品

采了一晚上，又出现这样错误了，汗，不知道有没有全部采完

1. 2013-06-26 06:43:07,640 [1] ERROR System.Object [(null)] - UI Exception:
   
2. System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   
3.    at System.Windows.Forms.RichTextBox.StreamOut(Int32 flags)
   
4.    at System.Windows.Forms.RichTextBox.get_Text()
   
5.    at F892D034DB81E03912D8A86B31C5DB.A007881DAC35906EB08D11CE8868FC2F9.E9E40E41335F16B4A12DED075B054C.
   
6. .AA1F0C8CB22E3623CE81339D34C1BEB92(Object
   
7. 1
   
8. , EventArgs
   
9. 2
   
10. )
    
11.    at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
    
12.    at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
    
13.    at System.Threading.ExecutionContext.runTryCode(Object userData)
    
14.    at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
    
15.    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
    
16.    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
    
17.    at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
    
18.    at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
    
19. 2013-06-26 07:00:05,562 [72] FATAL System.Object [(null)] - No-UI Exception:(IsTerminating:True)
    
20. System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
    
21.    at System.String.InternalSubString(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
    
22.    at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
    
23.    at System.Text.RegularExpressions.Capture.get_Value()
    
24.    at Super.Parse.Article.OO1OllOlOl0OOO01OO.<GetRuleContent>b__3(Object O1l00)
    
25.    at Super.Parse.Article.O00OO01O10lOl110Ol.<TryExecute>b__0()
    
26.    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
    
27.    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
    
28.    at System.Threading.ThreadHelper.ThreadStart()
    

复制代码