> Actually I can read 10 MByte from an Oracle DB (on another machine)
> via ODBC in less than 2 seconds... I don't know if that's good or bad
> though, you tell me ;)
Pretty good! That works out to 5 megabyte per second. That's gotta
be gigabit ethernet. I don't think the 10 meg stuff will sustai
Subject: RE: [sqlite] BLOB problem
Won't reading multi-megabyte objects through odbc be *horribly* slow?
If you're not searching the contents of the blob it's probably better
stored as files with a path in the database instead.
@sqlite.org
Cc:
Subject: Re: [sqlite] BLOB problem
On Thu, 2005-02-24 at 15:05 +0100, Bielik, Robert wrote:
> Hmmm... what is this? When using sqlite3_get_table it goes through
sqlite3_exec which extracts
> values from columns with sqlite3_column_text (!!!)
I use the api sqlite3_bind_blob.
Albert
On Thu, 2005-02-24 at 15:05 +0100, Bielik, Robert wrote:
> Hmmm... what is this? When using sqlite3_get_table it goes through
> sqlite3_exec which extracts
> values from columns with sqlite3_column_text (!!!). What about blobs? A blob
> can actually contain
> a number of null bytes! What is the r
Hmmm... what is this? When using sqlite3_get_table it goes through sqlite3_exec
which extracts
values from columns with sqlite3_column_text (!!!). What about blobs? A blob
can actually contain
a number of null bytes! What is the recommended procedure to extract a blob if
sqlite3_exec doesn't cut
6 matches
Mail list logo