<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi.<br>
<br>
I don't know if the problem is related to having all this tables
joined in gvSIG.<br>
<br>
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.<br>
<br>
Hope it helps.<br>
<br>
Fran.<br>
<br>
PS: Happy New Year to everyone!! :-)<br>
<br>
El 29/12/2010 8:36, Jan Zvonik escribió:
<blockquote
cite="mid:AANLkTikteHTJcehOQRzkT2DZcs757bCMVNo7uL9dbE2K@mail.gmail.com"
type="cite">
<div>Hello,</div>
<div><br>
</div>
<div>we have been developing a "Cadastral Passport extension" for
gvSIG, which means database of cadastral parcel data and
ownership. </div>
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>The problem seems to be absence of caching driver within
gvSIG application.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thank you in advance</div>
<div><br>
</div>
<div>Jan Zvonik</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Gvsig_internacional mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a>
<a class="moz-txt-link-freetext" href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Fran Peñarrubia
Scolab
<a class="moz-txt-link-abbreviated" href="http://www.scolab.es">www.scolab.es</a>
Asociación gvSIG
<a class="moz-txt-link-abbreviated" href="http://www.gvsig.com">www.gvsig.com</a>
</pre>
</body>
</html>