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
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
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.
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
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
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
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
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,
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
9 matches
Mail list logo