Look at disc transfer. With 16 queries in one thread on single disc, disc may be accesed linearly (depeding on query). With 16 threads accesing disc at the same time linear disc access is impossible (however os may do some prefetching) and queries will by slower. You may try increasing page size - bigger block means less near-random reads from the disc. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] Read only scaling optimization Drew Kozicki
- Re: [sqlite] Read only scaling optimization Simon Slavin
- Re: [sqlite] Read only scaling optimization Richard Hipp
- Re: [sqlite] Read only scaling optimization Teg
- Re: [sqlite] Read only scaling optimization Wiktor Adamski
- Re: [sqlite] Read only scaling optimization Alexey Pechnikov
- Re: [sqlite] Read only scaling optimization Drew Kozicki
- Re: [sqlite] Read only scaling optimization Drew Kozicki
- Re: [sqlite] Read only scaling optimization Simon Slavin
- Re: [sqlite] Read only scaling optimization Drew Kozicki
- Re: [sqlite] Read only scaling optimization Simon Slavin
- Re: [sqlite] Read only scaling optimization Pavel Ivanov
- Re: [sqlite] Read only scaling optimizat... Alexey Pechnikov
- Re: [sqlite] Read only scaling optimization Drew Kozicki
- Re: [sqlite] Read only scaling optimization Pavel Ivanov