2011/8/10 Wiktor Adamski <bardzotajneko...@interia.pl>: > You > may try increasing page size - bigger block means less near-random > reads from the disc.
It's good way. With page size 8k instead of default 1k selects performance may increasing ~3x. Note: PostgreSQL use 8k disk pages. -- 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