FileCache vs DbCache vs Other

Topics: SharpMap v0.9 / v1.x
Editor
May 22, 2014 at 9:23 PM
Hi,

Does anyone have any idea on the performance of a dbcache vs a file based cache for brutile map tile providers?

Or any other caching method that would perform better?

Thanks
Coordinator
May 23, 2014 at 7:33 AM
DbCache with SQLite is almost as fast as FileCache.
DbCache with SqlSever Compact Edition is awfully slow. At least it has been.

I must admit that I have not tried it with a "real" database.
Editor
May 23, 2014 at 9:26 AM
Thats odd I would have thought that a dbCache would have be more performant!

This would be a full sql server enterprise edition.

I'm guessing that the dbcache would scale better in performance than a large filecache, or is that incorrect?