[Bioc-devel] size limit of a string or a BLOB
sfalcon at fhcrc.org
Sat Sep 29 16:26:53 CEST 2007
This might be better directed to the R-sig-db list. But anyway...
Simon Lin <simonlin at duke.edu> writes:
> I have got the following error message when using RSQLite. So, what is
> the size limit of a string? and what is the limit of the BLOB (by
> defination, I assume it shoud be in the TB range at least)? Thanks! -Simon
> # trying to insert a DNA sequence of about 500MB into a table
> > query01<-dbSendQuery(connect, statement = paste ("
> + insert into dna values ('", seq0, "')", sep="")
> + )
> Error in sqliteExecStatement(conn, statement, ...) :
> RS-DBI driver: (error in statement: String or BLOB exceeded size limit)
This is a Sqlite error message, that is, not something being generated
in RSQLite directly. The hard coded limit from the SQLite sources
is just undr 1GB. Here's the relevant SQLite code:
** The maximum length of a TEXT or BLOB in bytes. This also
** limits the size of a row in a table or index.
** The hard limit is the ability of a 32-bit signed integer
** to count the size: 2^31-1 or 2147483647.
# define SQLITE_MAX_LENGTH 1000000000
How many columns does the dna table have? Perhaps there is a
different way to organize the data?
Seth Falcon | seth at userprimary.net | blog: http://userprimary.net/user/
More information about the Bioc-devel