On Thu, Jul 9, 2009 at 12:36 AM, Tom <[email protected]> wrote: > Now to list + fixed a typo. > > On Thu, Jul 9, 2009 at 12:35 AM, Tom <[email protected]> wrote: > >> On Wed, Jul 8, 2009 at 11:14 PM, Vikas Saurabh >> <[email protected]>wrote: >> >>> > >>> > It works great when you don't have any (a lot of) calls :) >>> > >>> My timings (roughly): >>> * Loading message followed by UI -- some 6 seconds >>> * Complete list -- (27-6=21seconds) >>> Does these look alright? (BTW, thats definitely improved timing...but >>> still seems a little slow considering that I might want to see 'who >>> called me?' upon noticing a missed call!! >>> >>> The contacts app enlists all contacts in 6 seconds, so I think the 6 >>> seconds above would be about loading python app and enumerating SIM >>> contacts. But the rest of the thing still takes 21 seconds >>> >>> The 'all' tab has some 60 records (after expanding the twirl-downs). >>> Moreover, if its of some help, my /var/log/phonelog.db is around 32K. >>> >>> --Vikas >>> >> >> are you sure you added my fix? here my phonelog.db is 100k and it only >> takes ~10 seconds (first test was with a trimmed down log). >> Weird... Maybe try >> SELECT * FROM calls; >> in sqlite3 and see how much time it takes... if more than a milisecond, >> that may be the issue ;) anyhow I'll optimize pyphonelog's queries sometime, >> hopefully tomorrow, and will try to make everything quicker... in general >> this db could use some more indexes. (not too many, but a bit more). >> >> Tom. >> >> > Another update, new pyphonelog will be built soon, changes:
- Pages now refresh on each page switch, and loading time is therefore shorter. Most of the time you just want to see the missed calls, so it should laucnh faster if nothing else is initialized, and if you still want to see something else, you can switch a tab. furthermore, if you switch a tab it's now updated which means you don't have to restart the phonelog app everytime. - optimized sql a bit and added more debugging info Please review if it speed up anything. here it did a good job. I only wait for app to start and for contacts to be retrieved, this will also be optimized soon. Tom.
_______________________________________________ Shr-User mailing list [email protected] http://lists.shr-project.org/mailman/listinfo/shr-user
