System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 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:
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.