Hi,
I'm wondering if we shall create datastore specific documentation
pages where hints, suggestions odds and ends of each datastore
can be summarized.
What prompts me is that I managed to test data clustering
on the data we have on artois.openplans.org.... I was
experiencing quite a slow a bumpy data load, the bottleneck
was clearly the db.
Well, doing the following:
alter table myTable alter the_geom set not null;
cluster myTableGeometryIndex on myTable;
sped up thins significantly by reordering data on the
disk along the spatial index (and I ended up with the
usual stuff, geoserver bottlenecked by labelling).
This is just one of the things that could end up in
datastore specific pages.
Soo... do we create a new section in the user guide,
datastore/format specific guidelines?
Cheers
Andrea
What would be the reason not to do this?
+1 from me (unless someone points out something bad that I haven't
thought of, I guess)
--saul
On Mon, 2007-10-29 at 20:23 +0100, Andrea Aime wrote:
Hi,
I'm wondering if we shall create datastore specific documentation
pages where hints, suggestions odds and ends of each datastore
can be summarized.
What prompts me is that I managed to test data clustering
on the data we have on artois.openplans.org.... I was
experiencing quite a slow a bumpy data load, the bottleneck
was clearly the db.
Well, doing the following:
alter table myTable alter the_geom set not null;
cluster myTableGeometryIndex on myTable;
sped up thins significantly by reordering data on the
disk along the spatial index (and I ended up with the
usual stuff, geoserver bottlenecked by labelling).
This is just one of the things that could end up in
datastore specific pages.
Soo... do we create a new section in the user guide,
datastore/format specific guidelines?
Cheers
Andrea
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
Don't we have this?
http://docs.codehaus.org/display/GEOSDOC/DataStores
I guess each could have a 'hints and tricks' section.
Chris
Andrea Aime wrote:
Hi,
I'm wondering if we shall create datastore specific documentation
pages where hints, suggestions odds and ends of each datastore
can be summarized.
What prompts me is that I managed to test data clustering
on the data we have on artois.openplans.org.... I was
experiencing quite a slow a bumpy data load, the bottleneck
was clearly the db.
Well, doing the following:
alter table myTable alter the_geom set not null;
cluster myTableGeometryIndex on myTable;
sped up thins significantly by reordering data on the
disk along the spatial index (and I ended up with the
usual stuff, geoserver bottlenecked by labelling).
This is just one of the things that could end up in
datastore specific pages.
Soo... do we create a new section in the user guide,
datastore/format specific guidelines?
Cheers
Andrea
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
!DSPAM:4005,47263335167121030819293!
Chris Holmes ha scritto:
Don't we have this?
http://docs.codehaus.org/display/GEOSDOC/DataStores
I guess each could have a 'hints and tricks' section.
Doh... it's so down in the page hierarchy I've never
noticed it.... maybe we should push it one level
up so that it shows in the summary?
Cheers
Andrea
Hey, surprisingly there's no ArcSDEDataStore page though it existed in the
geoserver documentation for ages.
It seems to have been moved to the geotools space:
<http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore>
So question is, saul any idea on how to document sde for both geotools and
geoserver without duplication at all?
And given Saul's involvement I guess its time to remove the initial
statement "ArcSDE is a one of the less tested...". See neither the oracle
statement is so discouraging 
cheers,
Gabriel
On Monday 29 October 2007 08:27:23 pm Chris Holmes wrote:
Don't we have this?
http://docs.codehaus.org/display/GEOSDOC/DataStores
I guess each could have a 'hints and tricks' section.
Chris
Andrea Aime wrote:
> Hi,
> I'm wondering if we shall create datastore specific documentation
> pages where hints, suggestions odds and ends of each datastore
> can be summarized.
>
> What prompts me is that I managed to test data clustering
> on the data we have on artois.openplans.org.... I was
> experiencing quite a slow a bumpy data load, the bottleneck
> was clearly the db.
>
> Well, doing the following:
> alter table myTable alter the_geom set not null;
> cluster myTableGeometryIndex on myTable;
>
> sped up thins significantly by reordering data on the
> disk along the spatial index (and I ended up with the
> usual stuff, geoserver bottlenecked by labelling).
>
> This is just one of the things that could end up in
> datastore specific pages.
>
> Soo... do we create a new section in the user guide,
> datastore/format specific guidelines?
>
> Cheers
> Andrea
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>
> !DSPAM:4005,47263335167121030819293!
Gabriel,
I guess we should probably split the parts on the GEOTDOC page out into
a GEOSDOC part, and a GEOTDOC part. There's definitely lots to document
in the various bits (not the least of which is the simplified geoserver
arcsde configuration now that the dummy-compiled version is
binary-compatible with the esri-compiled version)
--saul
On Tue, 2007-10-30 at 14:43 +0100, Gabriel Roldán wrote:
Hey, surprisingly there's no ArcSDEDataStore page though it existed in the
geoserver documentation for ages.
It seems to have been moved to the geotools space:
<http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore>
So question is, saul any idea on how to document sde for both geotools and
geoserver without duplication at all?
And given Saul's involvement I guess its time to remove the initial
statement "ArcSDE is a one of the less tested...". See neither the oracle
statement is so discouraging
cheers,
Gabriel
On Monday 29 October 2007 08:27:23 pm Chris Holmes wrote:
> Don't we have this?
>
> http://docs.codehaus.org/display/GEOSDOC/DataStores
>
> I guess each could have a 'hints and tricks' section.
>
> Chris
>
> Andrea Aime wrote:
> > Hi,
> > I'm wondering if we shall create datastore specific documentation
> > pages where hints, suggestions odds and ends of each datastore
> > can be summarized.
> >
> > What prompts me is that I managed to test data clustering
> > on the data we have on artois.openplans.org.... I was
> > experiencing quite a slow a bumpy data load, the bottleneck
> > was clearly the db.
> >
> > Well, doing the following:
> > alter table myTable alter the_geom set not null;
> > cluster myTableGeometryIndex on myTable;
> >
> > sped up thins significantly by reordering data on the
> > disk along the spatial index (and I ended up with the
> > usual stuff, geoserver bottlenecked by labelling).
> >
> > This is just one of the things that could end up in
> > datastore specific pages.
> >
> > Soo... do we create a new section in the user guide,
> > datastore/format specific guidelines?
> >
> > Cheers
> > Andrea
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems? Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Geoserver-devel mailing list
> > Geoserver-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> >
> > !DSPAM:4005,47263335167121030819293!