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. > >
_______________________________________________ Shr-User mailing list [email protected] http://lists.shr-project.org/mailman/listinfo/shr-user
