Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

2009-04-17 Thread Vinnie
> From: John Machin > Irrespective of what people tell you and how authoritative > they seem, I > would recommend that you do some simple tests: Excellent advice! Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

2009-04-16 Thread John Machin
On 17/04/2009 12:01 AM, Vinnie wrote: > Dear Group: > > I've done some calculations and its a fairly likely scenario that my users > will end up with sqlite databases that are over 1 gigabyte in size, in some > cases 4 gigabytes. An upper limit on the number of rows in a table could be > as hig

Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

2009-04-16 Thread Gerry Snyder
Vinnie wrote: > . > > Is there a limit to the database size on Windows or Macintosh? > > Does the following help? http://sqlite.org/limits.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listi

[sqlite] Limit to database and/or blob size on Mac/Windows?

2009-04-16 Thread Vinnie
Dear Group: I've done some calculations and its a fairly likely scenario that my users will end up with sqlite databases that are over 1 gigabyte in size, in some cases 4 gigabytes. An upper limit on the number of rows in a table could be as high as 100,000 (yeah that not very high). There are