Thread: Aura H2O open book very slow
View Single Post
Old 09-07-2016, 08:24 PM   #16
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
We are gettiing off the topic, but, here is the list of events I worked out some time ago. There are some new one, and some others I haven't deciphered.

Code:
Id		Description
0		Sync with Kobo 				- One for each book synced, but only when a new book is downloaded?	LastOccurence is updated
3		Open book
4		Started a digital library	- One for each kepub
5		Finished book
6		?							- Single record. ExtraData appears to be a series of timestamps.
9		One for every dictionary lookup 							- Multiple identical rows. Removing all except one speeds up dictionary lookup.
35									- Used for Booklover award
36									- Used for Booklover award
38									- One per kepub. Appears to record each time a book is downloaded from the server
46		Turn page
47		Read all night
48		Read all night
63
80 		Page Turner ("Read two hours straight")
1001	Read 12am-1am
1002	Read 1am-5am
1004	Read 7am-9am
1005	Read 9am-12am
1006	Read 12pm-2pm
1007	Read 2pm-4pm
1008	Read 4pm-6pm
1009	Read 6pm-8pm
1010	Read 8pm-10pm
1011	Read 10pm-12pm
1020	Open book?
1021	Close book?
99999	Just for kepubs
davidfor is offline   Reply With Quote