Touch Does number of books affects performance ?

[Koboyashi]

Originally Posted by Nigol

... I can't understand why it would slow down like this, because it is a database and having 5 or 1000 item in it shouldn't take more time to access it. I can understand at startup it would need to scan for new files, but for closing a book?

I think it's about the Reading Life feature. There is a table in the database called 'Event', where a lot of book events are present, maybe the book closing events too to calculate the average minutes each session per book. That could trigger the slow down if you have hundreds of books. Just switch off Reading Life to test it. For me, it's useless to test this because I have 'only' about 50 books so far.

[baronrus]

I have had several hundred and never noticed slowdown, however if one or more of the books has some sketchy formatting or if your data base is not 100% that could certainly slow things down or cause it to be unstable.

It seems to me that the more books you have the greater the chance that one or more of them will have some funny formatting issues or perhaps they were converted poorly at some point?

[frankieGom]

Originally Posted by Nigol

I can't understand why it would slow down like this, because it is a database and having 5 or 1000 item in it shouldn't take more time to access it. I can understand at startup it would need to scan for new files, but for closing a book?

In a Relational DBMS there are a number of ways that database queries can be crafted, some better than others, some definitely worse, and I can easily believe that a poorly written query could yield significantly lower performances on bigger databases. Is this the case here, I do not know, but the best os probably to open a ticket so the problem can be checked by the development team.

François