Hello all,

Sorry about the time it took me to fix this (it didn't really bothered me
and didn't really had the time, but lately I found it people don't like this
sluggishness).
Quick tech explanation: the bug is a lack of proper indexing in the sql
database created by ophonekitd, my fix: adding those indexes :)

This should be fixed in the latest ophonekitd (being built atm) though since
we don't yet do upgrade paths (i.e upgrade packages correctly, since this is
the unstable branch), you have three choices:

   1. after ophonekitd upgrade: rm /var/db/phonelog.db
   2. reflash (will have to wait until a new image is created)
   3. best course of action (also saves phonelog data):
      1. opkg install sqlite3
      2. sqlite3 /var/db/phonelog.db
      3. CREATE INDEX call_ids_id_idx ON call_ids (id);
      4. CREATE INDEX call_events_id_idx ON call_events (id);
      5. enjoy.

here it dropped phonelog's loading time from 3 minutes to 3 seconds. the
main bottleneck is now getting contacts from sim that will be addressed asap
(minor change) and then the only bottleneck will be the slow loading of
python apps on the moko, which isn't *that* bad.

Sorry for the hassle, though I thought this will interest many users.

Yours,
Tom (TAsn).
_______________________________________________
Shr-User mailing list
[email protected]
http://lists.shr-project.org/mailman/listinfo/shr-user

Reply via email to