Hello! On Tuesday 09 March 2010 20:09:04 Kiril wrote: > Fixes? Am I doing something wrong? >
You may do these: 1. Use transactions 2. Increase page_size (as example, PostgreSQL use 8k pages by default) 3. Increase default_cache_size (your biggest index size must be smaller than page_size*cache_size) Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users