Re: [sqlite] concers about database size

2006-03-16 Thread Kervin L. Pierre
Hello Daniel, Daniel Franke wrote: Was sqlite designed for those numbers? The docs state that sqlite supports "databases up to 2 terabytes in size". OTOH, "supports" is not the same as "works-well-with"?! Any suggestions whether my descision to use sqlite was appropiate for this table design?

Re: [sqlite] concers about database size

2006-03-16 Thread Jay Sprenkle
On 3/16/06, Daniel Franke <[EMAIL PROTECTED]> wrote: > Hi all ... > a couple of days back, I had a question about the performance of large > tables. You really got me going there, thanks again! > > But now, there's another thing.I figured out how large my database > will become and I'm scared of it

[sqlite] concers about database size

2006-03-16 Thread Daniel Franke
Hi all ... a couple of days back, I had a question about the performance of large tables. You really got me going there, thanks again! But now, there's another thing.I figured out how large my database will become and I'm scared of its size: up to 20GB and more! A single table, 4 columns, each hol