On 8 Jul 2014, at 6:51am, Manoj <[email protected]> wrote:
> Am using SQLite jdbc 3.7.2 and in a scenario i have a table with 2300 column > which eventually throwed too many columns exception since the maximum > allowed column count is 2000. > > Is there any workaround available for this? Maybe a query to increase column > limit in SQLite jdbc? I cannot conceive of any way to hold the definitions of 2300 columns in your head at one time. Therefore your database is badly designed. It might be worth remembering that given the design of SQLite, if you need the value of column 1900 of a specific row, SQLite has to read 1900 values in order to find that value. Are these columns numbered ? If so, you have a relational database and should be using a related table. Do the columns come in sets (e.g. 23 sensors each measuring 100 things) ? If so, you still have a relational database and should be using a table (e.g. of sensors) a relation. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
