[mapguide-internals] improving the tilecache storage mechanism with an addtional one

[Traian Stanev]

I'm not sure it makes sense to overlay Resource Service semantics on a tile cache. :) Sorry for the pithy response, but this reasoning does go both ways... 

We should talk about the relative performance of the two databases instead of jumping immediately to discussing which one would be easier to use with the current implementation of the resource service.

In the end, Zack is talking about backing up one large file -- it doesn't matter if it's a giant Berkeley database or a giant SQLite database.

Traian

P.S. We could replace the resource service to use SQLite and then we would be on the same page.


-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
Sent: Tuesday, May 04, 2010 11:07 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] improving the tilecache storage mechanism with an addtional one

Yes you can.  Currently we use Fdo to access sqlite.  I'm not sure it makes sense to overlay Fdo semantics on a tile cache.  As far as I know, the MapGuide server does not link directly to SQLite.

Trevor


-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Traian Stanev
Sent: May 4, 2010 9:03 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] improving the tilecache storage mechanism with an addtional one


Sure, but you can also have a sqlite file resource.


Traian


-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
Sent: Tuesday, May 04, 2010 10:57 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] improving the tilecache storage mechanism with an addtional one

Hi Train,

BerkeleyDb is already built directly into the MapGuide Server.  Tile caches could be written as an extension to the resource service.  Sharing tile caches may be easier if they are just resources.

Trevor


-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Traian Stanev
Sent: May 4, 2010 8:14 AM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] improving the tilecache storage mechanism with an addtional one


A tangential question: what is the advantage of BerkeleyDb over SQLite?

Traian


-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Tuesday, May 04, 2010 7:39 AM
To: MapGuide Internals Mail List
Subject: [mapguide-internals] improving the tilecache storage mechanism with an addtional one

One issue i have found at many client sites is that big tile caches tend to be not very backup friendly.

I do love being able to use http exposed tile cache, but I think there's some benefit in also supporting a sqllite or similiar storage mechanism as opposed to millions and millions of tiny image files.

I was chatting to trevor about this and he suggested using Berkely for this

one big file (or one per scale) is much more managable for our dear sysadmins

thoughts?

--
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168
_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals
_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals