sqlite3_changes() using 64 bit counters?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

sqlite3_changes() using 64 bit counters?

Detlef Golze
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.

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: sqlite3_changes() using 64 bit counters?

Donald Griggs
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: sqlite3_changes() using 64 bit counters?

Detlef Golze
The maximal number of rows is 1e+13 (<http://sqlite.org/limits.html>).

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.

-----Original Message-----
From: sqlite-users [mailto:[hidden email]] 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 billion rows in a single
transaction?
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: sqlite3_changes() using 64 bit counters?

Gelin Yan
On Fri, Dec 9, 2016 at 10:09 PM, Detlef Golze <[hidden email]> wrote:

> The maximal number of rows is 1e+13 (<http://sqlite.org/limits.html>).
>
> 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.
>
>
>
  It is my first time to know sqlite is used to store 2^32 rows data.

Regards

gelin yan
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: sqlite3_changes() using 64 bit counters?

Simon Slavin-3

On 10 Dec 2016, at 4:53am, Gelin Yan <[hidden email]> 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 mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users