Thread: Aura H2O open book very slow
View Single Post
Old 09-06-2016, 10:00 PM   #9
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by PeterT View Post
If davidfor see's this I wonder if it might be database related? Doesn't nickle add some data to the database on opening a book (the activity table I think)?
Yes, each time you open a book, there are several database updates. They mark the book as opened, add an entry to the event table to indicate the book has been opened, or update the counter if the book is being reopened. The number of rows in the event table grows more books are added and read. The rows don't get removed if the books is removed as this is used for some of the stats (such as books finished, hours read). But, I don't have any feel that this is causing a significant problem. To test that, you would need to remove all the current event rows and see if there was a difference. I haven't had a desire to do that.
davidfor is offline   Reply With Quote