Caio Honma wrote: > > I was trying to query from a huge table (150,000,000 lines+) using a left > join statement, using mode csv and using an output to file.. after several > minutes I got the Disk I/O error. I searched this maillist for some > possible answers (tried to check_integrity, but the db was ok, then I > installed the Process Monitor). >
Can you enable logging via the SQLITE_CONFIG_LOG configuration option before calling any other SQLite APIs? This should help to narrow down the operation returning the error. http://www.sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiglog Example: void logging_callback(void *notUsed, int iCode, const char *zErrmsg){ /* handle output here... */ fprintf(stdout, "%d: %s\n", iCode, zErrmsg); } sqlite3_config(SQLITE_CONFIG_LOG, logging_callback, 0); -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users