<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=718072714-05032007>Dear members of the
list,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=718072714-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=718072714-05032007>I have serious
problems with the performance of loading joins into QGIS.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=718072714-05032007>The joins are made
between spatial and non-spatial tables. It seems that this depends not to the
size of a join. Both tables could be really small in size (t1: 10col, 20rows;
t2:10col, 120rows).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=718072714-05032007>Displaying or
loading the join needs a lot time and the system do not react any more. Once the
join is loaded as a layer the working speed is gone to normal and good. Queries
on tables and listing attributes is working fine also. Also the displaying of
the data in pgadmin or on the commandline interface is good and fast, so I guess
it does not depend on indicies and vacuuming the database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=718072714-05032007>I tested it with
version 0.74 and 0.8 of QGIS on Windows and on Linux (Ubuntu 6.06 and 6.10)
machines. Also locally on the database server as well as over a network
connection to the server.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=718072714-05032007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=718072714-05032007>Anyone of you have
an idea whats going on here?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=718072714-05032007><FONT face=Arial size=2>Thanks in
advance,</FONT></SPAN></DIV>
<DIV><SPAN class=718072714-05032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=718072714-05032007><FONT face=Arial
size=2>Christian</FONT></SPAN></DIV>
<DIV align=left><FONT face=Helv>
<P align=left><FONT face=Arial
size=2>_________________________________________</FONT></P>
<P><FONT face=Arial size=2>Mit freundlichen Grüßen</FONT></P>
<P><FONT face=Arial size=2>Dipl. Geogr. Christian Braun<BR>Mail: </FONT><A
href="mailto:christian.braun@tudor.lu"><FONT face=Arial
size=2>christian.braun@tudor.lu</FONT></A></P>
<P><FONT face=Arial size=2>Resource Centre for Environmental
Technologies,<BR>Public Research Centre Henri Tudor,<BR>Technoport
Schlassgoart,<BR>66 rue de Luxembourg,<BR>P.O. BOX 144,<BR>L-4002
Esch-sur-Alzette, Luxembourg</FONT></P></FONT></DIV>
<DIV> </DIV></BODY></HTML>