Thanks! The Online Backup API does exactly what I want. 2011/3/21 Drake Wilson <[email protected]>: > That depends on your application. In general if you think too many > file accesses is a speed problem and you are willing to spend more > memory to deal with it, some of the first things to try would be > fiddling with the cache_size, synchronous, and journal_mode PRAGMAs, > depending on what tradeoffs you want to make.
I'm thinking of using it in a relatively small database which is going to be accessed often. But maybe increasing the cache_size would be better. Maybe having it all in memory could be problematic if it's not big enough. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
