On 9 Jan 2013, at 10:59pm, Bebel <gi.bella...@live.fr> wrote: > Now my problem is that my limitation for increase my latency is on the > amount of IO ops perform by the databases. In fact, sqlite make a lot of > random IO on my disks (many hundred) and this increase my disk latency. > > I made a test on a empty database, on which I insert a value and then read > it. This two sqlite operations made more than 40 IO operation.
Are you including in those 40 operations the opening and closing of the database files ? Opening the database file is complicated and takes many operations. By having many tiny databases instead of fewer big databases you are going to spend a lot of time just changing which database you have open. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
