It's rarely a good idea to use binary numbers for limits such as that -
you're exposing yourself to more corner case bugs.
Interesting issue...
I thing that we may use 2048 instead 2000. It´s an
number more "binary". I think that it´s sufficient to
99.99% of the possible applications.
That´s a good idea. The DBase accepted 128 collumns
and that is my reference. I've need more than this.
In a future development this value will be editable?
Cláudio Leopoldino
> As currently implemented, there is no fixed limit to
> the number
> of columns you can put in a table in SQLite. If the
> CREATE TABLE
> statement will fit in memory, then SQLite will
> accept it. Call
> the number of columns in a table K. I am proposing
> to limit the
> value of K to something like 2000.
>
> Would this cause anyone any grief?
>
> Note that SQLite is optimized for a K that is small
> - a few dozen
> at most. There are algorithms in the parser that
> run in time
> O(K*K). These could be changed to O(K) but with K
> small the
> constant of proportionality is such that it isn't
> worthwhile.
> So, even though SQLite will work on a table with a
> million or
> more columns, it is not a practical thing to do, in
> general.
>
> The largest value of K I have seen in the wild is in
> the
> low 100s. I thought that I was testing with K
> values in
> the thousands, but I just checked and I think the
> test
> scripts only go as high as K=1000 in one place.
>
> The reason it would be good to limit K to about 2000
> is
> that if I do so there are some places where I can
> increase
> the run-time performance some. It would also reduce
> code complexity in a few spots.
>
> So who out there needs a value of K larger than
> 2000?
> What is the largest K that anybody is using? Who
> would
> object if I inserted a limit on K that was in the
> range
> of 1000 or 2000?
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
Yahoo! Mail - Com 250MB de espaço. Abra sua conta! http://mail.yahoo.com.br/