MobileRead Forums - View Single Post

chaley · 04-28-2011, 05:34 PM

@kiwidude: did you run the create experiment more than once? There seems to be a first-time problem. I ran the test, and it created a few duplicate groups, taking 22 seconds! I then deleted the records from the DB using SQLiteSpy and ran it again. This time it took 1.3 seconds. Around 15 more runs all produce the same number.

I am thinking that the first time it runs, it needs to auto-create the indices or some such. Do you have evidence one way or the other?

04-28-2011, 05:34 PM	#205
chaley Grand Sorcerer Posts: 12,500 Karma: 8065348 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	@kiwidude: did you run the create experiment more than once? There seems to be a first-time problem. I ran the test, and it created a few duplicate groups, taking 22 seconds! I then deleted the records from the DB using SQLiteSpy and ran it again. This time it took 1.3 seconds. Around 15 more runs all produce the same number. I am thinking that the first time it runs, it needs to auto-create the indices or some such. Do you have evidence one way or the other?