Hullo all,

Including the following in my c-program:

  sql_rc = sqlite3_open_v2(database_name,
                             &sql_db,
                             SQLITE_OPEN_READONLY,
                             NULL);
     if (sql_rc != SQLITE_OK) {
        
       fprintf(stderr, "Function:%s can't open database:%s, error:%s\n",
              FLAG_MAIN, database_name,
              sqlite3_errmsg(sql_db));
        
       sqlite3_close(sql_db);
        
       return(FAIL);
     }


Causes a seemingly unrelated optimization issue elsewhere in the  
program where I read in some data from flat files. I.e. if the  
database is opened, the time taken to read in data from the flat files  
is much longer. This is very bizarre. I have bench marked the times  
and as stated earlier, the time taken "seems" directly related to  
whether the database is open/not. Not sure at all how to go about  
unravelling this mystery.

Ideas?



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to