On Mon, Nov 14, 2011 at 5:32 AM, Simon Slavin <slav...@bigfraud.org> 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 !
The requirement for a large number of columns is actually one thing that is often needed when using sqlite from R. Typically the use case is that a user wishes to read a portion of an external file into R and that file has thousands of columns. For example, each row might be an individual and each column is a gene. Or each row is a time point and each column is a security (stock, bond, etc.) The file may too large to reasonably handle in memory so rather than deal with it in chunks at a time its easier to just read it into sqlite in its entirety and then pick off the portion you want into R using sql. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
