Thanks for the reply. Therefore my expectation that the approach 3 should be the best is correct, isn't it? I mean, using a dedicated connection for each table should cause better reusablility of cached pages? Or what approach would you propose to get the best performance?
Does SQLite have any official (or internal) performance tests related to multiple connections or SQLite cache mechanism? Is it possible that managing of multiple connections can cause slowdown in SQLite itself? Regards, Milan
