Re: [sqlite] Database malformed after 6000 Inserts?

Are you accessing the database across a network, or is local on the server? Are you using a transaction, or are these individual inserts? I'm using system.data.sqlite.dll for a file backup program and that happily rattles through 800,000 inserts (continuously) without issues. Its worth noting that

Re: [sqlite] Database malformed after 6000 Inserts?

On 4 Oct 2016, at 6:30pm, Roger Binns wrote: > On 04/10/16 03:11, Werner Kleiner wrote: >> ... after 6000 records. >> >> Is there a limitation with huge inserts? > > While there may be "Lite" in the name, SQLite copes very well with > "huge" stuff. > > That means many

Re: [sqlite] Database malformed after 6000 Inserts?

On 04/10/16 03:11, Werner Kleiner wrote: > ... after 6000 records. > > Is there a limitation with huge inserts? While there may be "Lite" in the name, SQLite copes very well with "huge" stuff. That means many many gigabytes in database sizes, many many millions of rows, up to 2GB per row etc.

Re: [sqlite] Database malformed after 6000 Inserts?

On 4 Oct 2016, at 1:24pm, Werner Kleiner wrote: > Hopefully I give you the correct answer, because a collegue has > written the C# program. > We had no problems with inserts in the past, but now if we have > records about 6000 inserts we get the errors. > > The OS is

Re: [sqlite] Database malformed after 6000 Inserts?

We don't use Windows Server or System.Data.SQLite so can't comment. I'd be astonished if its Sqlite itself thats at fault here. Rob On 4 Oct 2016, at 13:24, Werner Kleiner wrote: Thanks for help. Hopefully I give you the correct answer, because a collegue has written the C# program. We had

Re: [sqlite] Database malformed after 6000 Inserts?

Thanks for help. Hopefully I give you the correct answer, because a collegue has written the C# program. We had no problems with inserts in the past, but now if we have records about 6000 inserts we get the errors. The OS is Server 2012, there are no pragma settings (but collegue has also used

Re: [sqlite] Database malformed after 6000 Inserts?

I had a problem similar to this before. What is the threading model for access to the database and how is the native library compiled and configured? Jim Borden (Sent from a mobile device) > On 4 Oct 2016, at 19:12, Werner Kleiner wrote: > > Hello, > a program written

Re: [sqlite] Database malformed after 6000 Inserts?

We've done inserts of tens of thousand at a time, we may well have done hundreds of thousands in one single transaction. I've no doubt other people do even larger transactions. I would assume the problem lies elsewhere. What error message are you getting? Whats the OS, the environment, disk,

[sqlite] Database malformed after 6000 Inserts?

Hello, a program written in C# makes inserts from an SQL script into a sqlite db. We now saw that the database will be malformed after 6000 records. Is there a limitation with huge inserts? What could be the problem? regards Werner ___ sqlite-users