On Nov 9, 2011, at 10:24 PM, Fabian wrote: > And I'd like to avoid to have some fuzzy logic > that tries to predicts which of the two methods is going to be faster.
Perhaps an alternative to your conundrum is the good, old "divide and conquer" approach. In other words, you could partition your data among multiple database files, using a simple hash to write into one partition or another. That, in combination with some astute use of 'attach', is as good an approximation as any of table partitioning in SQLite. http://en.wikipedia.org/wiki/Partition_(database) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
