I think too, if they are Big-Blobs, it is better to store only a Reference to a File. May i know litlle more clearly about this?What it mean actually?
Right now what i am doing is, I have a directory in which somany files are there and i have loaded all the files into database and the data(ie content of files as blob). But my application is reading only 512 bytes at a time..If that is the case how can i perform / handle this data . Please suggest me your views. Thanks a lot Sandhya R ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, September 18, 2006 12:51 PM Subject: Re: [sqlite] sqlite_blob > Hello > > sandhya wrote: > > Hi, > > Is there any way of reading Blob data for the given no.of bytes? > > I mean is there any lseek kind of function call in sqlite to handle > > reading BLOB data. > > http://www.sqlite.org/capi3ref.html says: > "If the result is a BLOB then the sqlite3_column_bytes() routine returns > the number of bytes in that BLOB." > > If you fetch the Blob into RAM, you can do with it with your given number > of Bytes whatever you want.... > > I think too, if they are Big-Blobs, it is better to store only a > Reference to a File. > > Best Regards > Thomas > > -- > www.thlu.de > > > -------------------------------------------------------------------------- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------------- --- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------