Current session overlay in map slow to update

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Start logging (with some ~60 sessions already in the DB, ~2000 WiFis each)
2. Go to map view
3. Move around and watch the update

What is the expected output? What do you see instead?
WiFis are often very slow to update. On many occasions, they don't get 
displayed at all before they scroll out of view.

What version of the product are you using? On what operating system?
rcd0f69c46f5b, Cyanogenmod 10.1.3-RC2

Please provide any additional information below.
This issue may be distinct from Issue 30 (it happens much earlier). I don't 
understand exactly how the code for DataHelper.loadWifisOverviewWithin() maps 
to a SQL query, but I suspect it searches an unindexed column, requiring a 
costly table scan. Just a shot in the dark: which table is used to look up the 
session_id? It's indexed in wifis but not in positions. The query would work 
either way, but looking up positions.session_id would take a lot longer...

Original issue reported on code.google.com by mich...@vonglasow.com on 19 Sep 2013 at 3:40

[GoogleCodeExporter]

Database indices are in place: de-serialization from database to objects is the 
real issue here..

Check out r77c0693a77b1 which skips costly de-serialization (we need only 
position data anyways, the whole rest is uninteresting at that point..)

With my test cases this measure increased performance by the factor 20x..
Looking forward for your experience.. If everything is good, I gonna close this 
issue soon

Original comment by wish7code on 19 Sep 2013 at 9:25

• Changed state: Started

[GoogleCodeExporter]

is there an APK available? Google Drive shows a "last modified" date of 
September 15 for the APK...

Original comment by mich...@vonglasow.com on 20 Sep 2013 at 11:01

[GoogleCodeExporter]

Google Drive seems unreliable in this: date doesn't always get update :-(
I just updated the binaries, so you can try out..

Original comment by wish7code on 23 Sep 2013 at 9:17

[GoogleCodeExporter]

Just tried r7f23a683d2b3 (built from source), the current track updates almost 
instantly. At times the GPS track is lagging a little and the WiFis are even 
faster. However, this goes only for the current session; WiFi catalog (issue 
30) is still an issue.

Original comment by mich...@vonglasow.com on 24 Sep 2013 at 10:08

[GoogleCodeExporter]

Original comment by wish7code on 25 Sep 2013 at 9:42

• Changed state: Fixed