Ticket Hash: | 36c60b26623461cda6a0785f7fc8dcbb34d01024 | |||
Title: | StackOverflowException in SQLiteCommand.ExecNonQuery() | |||
Status: | Closed | Type: | Feature_Request | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Native_Assembly | Resolution: | Not_A_Bug | |
Last Modified: | 2013-10-07 15:02:17 | |||
Version Found In: | 1.0.82.0 | |||
User Comments: | ||||
anonymous added on 2013-10-07 08:27:15:
(text/x-fossil-plain)
I generate a large insert query which inserts 72,000 rows and this seems to cause a a stackoverflow exception. The query only inserts 4 columns and they are all ints. I can email you a copy of the query if you need, its too large for paste bin etc. Thanks Steve mistachkin added on 2013-10-07 09:58:28: (text/x-fossil-plain) This is a limitation of the SQLite core library. I don't think it is designed to be capable of inserting 72000 rows in a single INSERT query, due to how it handles the C runtime stack. anonymous added on 2013-10-07 10:02:12: (text/x-fossil-plain) What is the maximum that can be insert? i think 500 seems like its limit? mistachkin added on 2013-10-07 15:02:17: (text/x-fossil-plain) I'm not sure as it depends on the amount of stack space available to your application. |