Hi! I have a large database, and running the VACUUM pragma hammers disk IO so badly that it dramatically affects performance on the box. I'm not in a hurry for the results, so I'm curious if you can think of a way using the API (or any other way) to essentially "nice" the process by inserting a short "sleep" into whatever loop runs inside the VACUUM command.
(I had initially thought of putting a sleep() into the callback to sqlite3_exec() callback, but that's only called once for each result row -- I need something that's called consistently through the running of the query.) Other alternatives we're considering are to fork and nice the process, or to call ioprio_set() directly, but I'm curious if there's a simpler way to do it. Thanks! -david _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
