trunk version has just received a new sqlite cache backend along with
the disk and memcache ones.
the configuration is straightforward:
<cache name="sqlite" type="sqlite3">
<!-- base
absolute filesystem path where the sqlite database files
will be stored.
this directory needs to be readable and writable by the user running
apache
-->
<base>/tmp</base>
<!-- hitstats
log last access time and total number of hits for each tile
in the cache.
note that this slows the tile accesses drastically as it
requires a write
to the database for each tile access
-->
<hitstats>true</hitstats>
</cache>
The backend will create a database file for each tileset/grid
combination, and also supports dimensions.
The schema isn't set in stone yet:
create table if not exists tiles(
x integer,
y integer,
z integer,
data blob,
dim text, /*not present if tileset has no dimensions */
ctime datetime,
atime datetime,
hitcount integer default 0,
primary key(x,y,z,dim)
)
From my limited testing, the performance accessing tiles this way is
very good, although not as fast as the disk cache.
regards,
thomas
I would consider putting the logs in a separate table so that the tiles
are write once and read mostly while the hits stats are mostly write.
This might speed things up a lot, but I have not tested that is the case.
-Steve
> --
> You received this message because you are subscribed to the Google Groups
> "mod-geocache" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/mod-geocache/-/IDSr-DlLYAwJ.
> To post to this group, send email to mod-ge...@googlegroups.com.
> To unsubscribe from this group, send email to
> mod-geocache...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/mod-geocache?hl=en.
>
Same error after changing both owner and permissions.
seeding level 1sqlite backend failed on set: SQL logic error or missing
databasesqlite backend failed on set: SQL logic error or missing
databasesqlite backend failed on set: SQL logic error or missing database
--
Mike
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
Seems to be working now.
Thanks!
--
Mike
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
I'm also noticing that while the cache is seeding, I'm seeing
error: sqlite backend failed on get: database is locked
When accessing tiles that are already generated. Does this mean that the
sqlite backend will be unavailable during the tile writes?
--
Mike
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
regards,
thomas
On Mon, Jul 25, 2011 at 00:43, Michael Smith