On Mon, 14 Sep 2009 06:09:45 -0700 (PDT), wlof
<wlo...@gmail.com> wrote:
>
>Thanks Kees. My app still needs some optimizations, your suggestions look
>good.
>
>One question though: what will happen when id reaches 2^32 - 1 ? (This app
>is going to log a lot of events, 24/7 for a long time, so it's not a purely
>theoretical question.)
SQLite uses 64 bit signed integers, so you get a max value
in the order of 2^63
= 9223372036854775810
10 events per second during 15 years
= 47304000000
See the difference? No issue.
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
