[Gvsig_english] Cadastral data postgis database problem

[Francisco José Peñarrubia]

Hi.

I don't know if the problem is related to having all this tables joined 
in gvSIG.

If this is the case, then try to avoid joining postgis tables. Instead 
of it, create a view in PostgreSQL and work with it. If you need 
geometry field, remember to add this geometry field and view to 
GEOMETRY_COLUMNS table.

Hope it helps.

Fran.

PS: Happy New Year to everyone!! :-)

El 29/12/2010 8:36, Jan Zvonik escribió:
> Hello,
>
> we have been developing a "Cadastral Passport extension" for gvSIG, 
> which means database of cadastral parcel data and ownership.
>
> The current database had been converted form proprietary Czech 
> Cadastral agency file format and data are stored in postgis DB. The 
> numerical part of DB consist of roughly 40 connected tables. We have 
> run into an unexpected problem when working with the database. The 
> data for each querry amount to some 5 MB but we found out that gvSIG 
> sends request and reloads data each time any operation is performed by 
> the user (map zooming, database querrying, filtering), which overloads 
> the application and prevents practical use of the exension.
>
> The problem seems to be absence of caching driver within gvSIG 
> application.
>
> However, I am sure there are applications that use gvSIG, remote 
> database (Posgis or other) and work with fairly large amount of data 
> that are working. So I am asking for any possible help with this 
> isssue. Is there any possible workaround for us? Or at least reference 
> to any other similar database application under gvSIG would be greatly 
> appreciated.
>
> Thank you in advance
>
> Jan Zvonik
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional

-- 
Fran Peñarrubia
Scolab
www.scolab.es

Asociación gvSIG
www.gvsig.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20101230/e9057094/attachment.htm