Thread
:
Plans for Maemo Mapper v2.0
View Single Post
ioan
2007-05-24 , 16:52
Posts: 481 | Thanked: 190 times | Joined on Feb 2006 @ Salem, OR
#
56
I did a test with creating a table just for the tile image and the crc32, the table looks like this:
CREATE TABLE testtable ([crc32] VARCHAR (8) PRIMARY KEY UNIQUE, [maptile] BLOB COLLATE NOCASE);
I didn't do anything for coordinates, nothing special to see there.
I ran the test on 213304 map tiles, and at the end, in the database I had 135417 unique tiles (77887 were duplicates!).
The 213304 tiles on my computer use 897MB (size on disk), and the database, after excluding the duplicates is about 290 MB.
I used sqlite3.
-ioan
Quote & Reply
|
ioan
View Public Profile
Send a private message to ioan
Visit ioan's homepage!
Find all posts by ioan