Re: [sqlite] Faster Alternative to sqlite3_blob_open

2012-02-17 Thread Roger Binns
On 17/02/12 14:51, Frank Chang wrote: I ran some tests today and found that sqlite3_blob_reopen is significantly faster than sqlite3_blob_open. Have you read the documentation? http://www.sqlite.org/c3ref/blob_reopen.html sqlite3_blob_reopen only works when you already have a blob handle o

Re: [sqlite] Faster Alternative to sqlite3_blob_open

2012-02-17 Thread Frank Chang
Roger Binns, I ran some tests today and found that sqlite3_blob_reopen is significantly faster than sqlite3_blob_open. Attached is the Very Sleepy Full Profiler report. The modified C++ code is shown below. Thank you. unsigned long *cIntersectingDedupe::GetSubGraphBlob(sSUBGRAPHINFO *S

Re: [sqlite] Faster alternative to sqlite3_blob_open

2012-02-17 Thread Roger Binns
On 17/02/12 05:09, Frank Chang wrote: Is it possible to find a faster alternative to sqlite3_blob_open? sqlite3_blob_open is the fast alternative! However you are reading the entire blob contents so it won't be that different than just using a regular SQL query. Also whatever you are using