[R] RSQLite maximum table size

From: Vidhu Choudhary <vidhu.choudhary_at_gmail.com>
Date: Wed, 16 Jul 2008 16:14:39 -0400


Hi All,
I am trying to make write a table in RSQLite. And I get the error mentioned below

 mat<-as.data.frame(matrix(rnorm(n=244000000),nrow=244000,ncol=1000))
> dbWriteTable(con, "array", mat)

[1] FALSE
*Warning message:
In value[[3]](cond) :
  RS-DBI driver: (error in statement: too many SQL variables)*

Can someone please tell me what is maximum size of a table( max number of rows and cols) we can have in RSQLite and how big the database can grow

Thank you
Regards
Vidhu

        [[alternative HTML version deleted]]



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed 16 Jul 2008 - 20:18:37 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 16 Jul 2008 - 20:33:58 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive