Skip to content
Prev 269 / 1559 Next
Original Raw

SQLite: When reading a table, a "\r" is padded onto the last column. Why?

Seth Falcon 
ronggui <ronggui.huang at gmail.com> writes:
Can you provide the exact call to read.table you used?  

To give it a fair chance, you need to use the colClasses arg in
read.table and choose a reasonable batch size (I think the buffer
hard-coded in the RSQLite C code is 1024, so to compare you should
choose a number of rows that is ~1MB).

+ seth
Message-ID: <m2ps9sku8s.fsf@fhcrc.org>
In-Reply-To: <38b9f0350701060214k1023f211yafa615d77f38d35d@mail.gmail.com> (ronggui's message of "Sat, 6 Jan 2007 18:14:29 +0800")
Back to archive Original archive Thread
19 / 19

Thread (19 messages)

Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 3 ronggui SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 3 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 ronggui SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 Dirk Eddelbuettel SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 ronggui SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 Dirk Eddelbuettel SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 4 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 ronggui SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 David James SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 Brian Ripley SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 David James SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 5 ronggui SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 6 Seth Falcon SQLite: When reading a table, a "\r" is padded onto the last column. Why? Jan 6