Generated The KML

I got in contact with the author of the software that I use to generate the route maps. He agreed that the program seemed needlessly slow. He looked into it and suggested I run a couple indexes on the database holding the data:

create index idx_gpstime on gps(time);
create index idx_obdtime on obd(time);

After this, the program runs in approximately one minute, versus something like one week before the optimization. That works out to a speed improvement of about ten thousand time. Wow.

So I generated the file and it is about 25 megabytes, which is too large to upload to the same place I keep the other KML files, and also too large for Google Maps to accept. I don't know what to do about that, but for now I'm just going to do nothing.

No comments:

Post a Comment