[sqlite] seeking sqlite3_progress_handler advice

[Will Leshner]

I'm wondering if anybody has any suggestions for a good number to  
pass as the second argument to sqlite3_progress_handler to indicate  
how many opcodes to wait before the progress handler is called. I  
realize it depends on a great many factors, so it is probably  
impossible to come up with a good general number. But I'm thinking  
I'd like to keep the progress handler from getting called at all for  
most typically short queries/commands and only have it get called for  
operations that are going to take longish amount of time. I am also  
planning to keep track of a time-based progress update interval in  
the progress handler, so I am not really depending on the opcode  
count. I'd just like to keep the progress handler from getting called  
too often.

Thanks.