On Thu, Jul 15, 2010 at 04:35:56PM +0300, Yoav Apter scratched on the wall:

> Using ProcMon we notice that when this happens, Sqlite is trying to
> open a new file with a gibberish name which explains the OS error.
> At what time does sqlite3_step needs top open a file (considering
> the database is opened in read-only mode?) what can explain the
> weird file name?

  Are the filenames "etilqs_XXXXXXXXXXXXXXXXXXXX" with "X" being a
  random alpha-numeric?  Those are temp files.

  It might be that a temp file is needed, but can't be created.  You
  might try keeping temp files in memory. 
  
  See: "PRAGMA temp_store = memory"

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to