I have a single threaded application, which at its heart is while (true) { open a database // any one of thousands, so I can’t just keep it open do a select close the database }
With that part unchanged, does anyone have any optimization suggestions? I am compiling the amalgamation myself, so I’m open to both compile time and run time options. I don’t need to worry about other processes updating the database. I’m not looking for SQL advice at this time. Openning the database with SQLITE_OPEN_READONLY was an enourmous help. Explicitly turning off threading didn’t seem to help much. Changing my compiler optimization level from -O2 to -O3 (gcc 4.4) made it larger but no faster. many thanks, adj _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users