Hi Simon In my application a ESB will update more than 2000 columns in simultaneously based on some algorithm processing in real time . So i need to create single table with 2000 columns updated based on result of processing of records.
So i need to know how extend no of columns per table for SQLite Table. Thanks Vinay Simon Slavin-3 wrote: > > > On 14 Nov 2011, at 7:38am, vinayh4 wrote: > >> I need to create table with more than 2000 columns, How to reset >> SQLITE_MAX_COLUMN value which >> is 2000 . Plz help me on this issue. > > You almost never need to have more columns than you can fit in your head > at one time. The way you handle 2000 columns is to make a database for > them ! > > Have you considered storing your data as triplets: > > row column value > 1 first 234 > 1 second 54.234 > 1 third 232.41 > ... > 2 first 432 > 2 second 23.413 > > ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/determine-SQLITE_MAX_LENGTH-or-sql_limit-sqlite3_limit-tp30885748p32839447.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users