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