|Title:||StackOverflowException in SQLiteCommand.ExecNonQuery()|
|Last Modified:||2013-10-07 15:02:17|
|Version Found In:||22.214.171.124|
anonymous added on 2013-10-07 08:27:15:
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:
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:
What is the maximum that can be insert? i think 500 seems like its limit?
mistachkin added on 2013-10-07 15:02:17:
I'm not sure as it depends on the amount of stack space available to your application.