[sqlite] Faster Alternative to sqlite3_blob_open

2012-02-18 Thread Frank Chang
sqlite3_blob_reopen.ppt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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

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

[sqlite] Faster alternative to sqlite3_blob_open

2012-02-17 Thread Frank Chang
Good morning,We have been using sqlite3_blob_open in the function below.When I profile the application using Very Sleepy I notice that sqlite3_blob_open is one of he biggest consumers of CPU time. Is it possible to find a faster alternative to sqlite3_blob_open? Thank you unsigned long