Re: [sqlite] sqlite3_changes() using 64 bit counters?

On 10 Dec 2016, at 4:53am, Gelin Yan wrote: > It is my first time to know sqlite is used to store 2^32 rows data. I can tell you I have a database in which one table takes up 39 Megabytes if that helps. Simon. ___ sqlite-users

Re: [sqlite] sqlite3_changes() using 64 bit counters?

On Fri, Dec 9, 2016 at 10:09 PM, Detlef Golze wrote: > The maximal number of rows is 1e+13 (). > > I do have tables with more than 2^32 rows. Of course one should avoid > making that large transactions, but it is possible. > > Regards, > dg.

Re: [sqlite] sqlite3_changes() using 64 bit counters?

s-boun...@mailinglists.sqlite.org] On Behalf Of Donald Griggs Sent: Thursday, December 08, 2016 7:00 PM To: SQLite mailing list Subject: Re: [sqlite] sqlite3_changes() using 64 bit counters? Just curious -- some of your tables approach 2 billion (2 milliard) rows? Or, more precisely, you operate on more than 2 b

Re: [sqlite] sqlite3_changes() using 64 bit counters?

Just curious -- some of your tables approach 2 billion (2 milliard) rows? Or, more precisely, you operate on more than 2 billion rows in a single transaction? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] sqlite3_changes() using 64 bit counters?

Hi, is there a plan for sqlite3_changes() and sqlite3_total_changes() returning 64 bit values? SQLite supports far more rows than a signed 32 bit counter can store and I would feel more comfortable if I don't need to check for an overflow. Thank you, Detlef.