Great amount of shapes with PostGIS

[Frank Koormann]

Hi Jens,

* JensMattke at aol.com <JensMattke at aol.com> [040407 19:40]:
>    Hi.
> 
>    I am designing a spatial database for my Diploma-Dissertation.
>    I would like to work with Thuban on tables containing up to 95.000 shapes
>    (I think this number is even increasing!). Unfortunately, this doesn't
>    work on acceptable speed.
>    It seems to me, Thuban reloads all the data from the database at every
>    action.
> 
>    I will have the chance to devide my tables, but I don't think this will
>    bring the number of shapes below 20.000.
>    Are there any plans in the near future, to keep the data persistent for a
>    session?

Thuban's PostGIS interface is the result of a thesis (with some revision
by Bernhard Herzog), it has been implemented under the paradigm 
'first make it work'. We are aware that there are numerous screws to
tune the DB connection and rendering in general. But Intevation is
currently not contracted to work on the optimization of this interface,
hence progress in that direction runs on low priority. So near term
improvements might be voluntary contributions. Although Bernhard is
quite busy this month, if someone is interested we could sketch some 
improvements.

Cheers,

        Frank

-- 
Frank Koormann                             <frank.koormann at intevation.de>
 Professional Service around Free Software       (http://intevation.net/)
 FreeGIS Project                                 (http://freegis.org/)