<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Arial","sans-serif";
color:#0070C0;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Hi Nathan<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Thanks for this, I’ve added the table and will see how I get on.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Thanks again<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Steve.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Nathan Woodrow [mailto:madmanwoo@gmail.com] <br><b>Sent:</b> 01 July 2013 11:23<br><b>To:</b> Steven Campbell<br><b>Cc:</b> qgis-user<br><b>Subject:</b> Re: [Qgis-user] OS Mastermap, SQL Server and QGIS<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hey Steven,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I didn't know about the sys,spatial_index_tesellations table. That might be better to use as it doesn't require the user to do any extra work. Ignore the min_x, min_y stuff I will update the code to use this new table and let you know once it's done.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>However creating the geometry columns table isn't a bad idea anyway as it will let QGIS find the layers quicker when using the browser, or list layers dialog.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Here is a create script:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal>CREATE TABLE [dbo].[geometry_columns](<o:p></o:p></p></div><div><p class=MsoNormal> [f_table_catalog] [varchar](128) NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> [f_table_schema] [varchar](128) NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> [f_table_name] [varchar](256) NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> [f_geometry_column] [varchar](256) NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> [coord_dimension] [int] NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> [srid] [int] NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> [geometry_type] [varchar](30) NOT NULL,<o:p></o:p></p></div><div><p class=MsoNormal> CONSTRAINT [geometry_columns_pk] PRIMARY KEY CLUSTERED <o:p></o:p></p></div><div><p class=MsoNormal>(<o:p></o:p></p></div><div><p class=MsoNormal> [f_table_catalog] ASC,<o:p></o:p></p></div><div><p class=MsoNormal> [f_table_schema] ASC,<o:p></o:p></p></div><div><p class=MsoNormal> [f_table_name] ASC,<o:p></o:p></p></div><div><p class=MsoNormal> [f_geometry_column] ASC<o:p></o:p></p></div><div><p class=MsoNormal>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<o:p></o:p></p></div><div><p class=MsoNormal>) ON [PRIMARY]<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>This is what mine looks like:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="http://i.imgur.com/sMWyvTk.png">http://i.imgur.com/sMWyvTk.png</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>- Nathan<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Mon, Jul 1, 2013 at 8:03 PM, Steven Campbell <<a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Hi Nathan</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Thanks for this info, excuse me for sounding a bit thick here, but as I can’t find any Geometry_columns table in my SQL database, I’m guessing I need to create one as QGIS uses this table to get the extents of the data in SQL, and if it doesn’t exist it works them out on the fly?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Do I have to use ogr2ogr to create this table or can I build the table and put in the information myself – or can I use the sys.spatial_index_tesellations table instead as this contains my bounding boxes for x and y?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Thanks</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'>Steve</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070C0'> </span><o:p></o:p></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Nathan Woodrow [mailto:<a href="mailto:madmanwoo@gmail.com" target="_blank">madmanwoo@gmail.com</a>] <br><b>Sent:</b> 01 July 2013 00:11<br><b>To:</b> Steven Campbell<br><b>Cc:</b> qgis-user<br><b>Subject:</b> Re: [Qgis-user] OS Mastermap, SQL Server and QGIS</span><o:p></o:p></p></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Hey Steven,</span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>There is a trick you can do to get your layers to load a bit quicker. The thing that takes the most time when loading a layer is calculating the extents, this is done each time the layer is opened and for large layers this can have a pretty big performance hit. So to fix that issue I have made the SQL driver search for a min_x, min_y, max_x, max_y in the geometry_columns table in order to just read the extent so there is no on the fly calculation needed when the layer is loaded.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>So your geometry_columns table should look like this:</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>f_table_catalog<span style='color:#666600'>]</span> <span style='color:#666600'>[</span>varchar<span style='color:#666600'>](</span><span style='color:#006666'>128</span><span style='color:#666600'>)</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>f_table_schema<span style='color:#666600'>]</span> <span style='color:#666600'>[</span>varchar<span style='color:#666600'>](</span><span style='color:#006666'>128</span><span style='color:#666600'>)</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>f_table_name<span style='color:#666600'>]</span> <span style='color:#666600'>[</span>varchar<span style='color:#666600'>](</span><span style='color:#006666'>256</span><span style='color:#666600'>)</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>f_geometry_column<span style='color:#666600'>]</span> <span style='color:#666600'>[</span>varchar<span style='color:#666600'>](</span><span style='color:#006666'>256</span><span style='color:#666600'>)</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>coord_dimension<span style='color:#666600'>]</span> <span style='color:#666600'>[</span><span style='color:#000088'>int</span><span style='color:#666600'>]</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>srid<span style='color:#666600'>]</span> <span style='color:#666600'>[</span><span style='color:#000088'>int</span><span style='color:#666600'>]</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>geometry_type<span style='color:#666600'>]</span> <span style='color:#666600'>[</span>varchar<span style='color:#666600'>](</span><span style='color:#006666'>30</span><span style='color:#666600'>)</span> NOT NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>min_x<span style='color:#666600'>]</span> <span style='color:#666600'>[</span><span style='color:#000088'>double</span><span style='color:#666600'>]</span> NULL<span style='color:#666600'>,</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>min_y<span style='color:#666600'>]</span> <span style='color:#666600'>[</span><span style='font-family:"Arial","sans-serif";color:#000088'>double</span><span style='font-family:"Arial","sans-serif";color:#666600'>]</span><span style='font-family:"Arial","sans-serif"'> NULL<span style='color:#666600'>,</span></span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>max_x<span style='color:#666600'>]</span> <span style='color:#666600'>[</span><span style='font-family:"Arial","sans-serif";color:#000088'>double</span><span style='font-family:"Arial","sans-serif";color:#666600'>]</span><span style='font-family:"Arial","sans-serif"'> NULL<span style='color:#666600'>,</span></span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre><span style='color:#666600'>[</span>max_y<span style='color:#666600'>]</span> <span style='color:#666600'>[</span><span style='font-family:"Arial","sans-serif";color:#000088'>double</span><span style='font-family:"Arial","sans-serif";color:#666600'>]</span><span style='font-family:"Arial","sans-serif"'> NULL</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre><span style='font-family:"Arial","sans-serif"'>The last four columns are the new ones and you can calculate a rough extents to go in the table like:</span><o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:.75pt .75pt .75pt .75pt'><pre style='text-align:right'><span style='color:#AAAAAA'> </span><o:p></o:p></pre><pre style='text-align:right'><span style='color:#AAAAAA'> </span><o:p></o:p></pre><pre style='text-align:right'><o:p> </o:p></pre><pre style='text-align:right'><o:p> </o:p></pre><pre style='text-align:right'><span style='color:#AAAAAA'> </span><o:p></o:p></pre></td><td style='padding:.75pt .75pt .75pt .75pt'><pre><span style='color:#000088'>select</span> min<span style='color:#666600'>([</span>ogr_geometry<span style='color:#666600'>].</span><span style='color:#660066'>STPointN</span><span style='color:#666600'>(</span><span style='color:#006666'>1</span><span style='color:#666600'>).</span>STX<span style='color:#666600'>),</span> <br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre> min<span style='color:#666600'>([</span>ogr_geometry<span style='color:#666600'>].</span><span style='color:#660066'>STPointN</span><span style='color:#666600'>(</span><span style='color:#006666'>1</span><span style='color:#666600'>).</span>STY<span style='color:#666600'>),</span> <br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre> max<span style='color:#666600'>([</span>ogr_geometry<span style='color:#666600'>].</span><span style='color:#660066'>STPointN</span><span style='color:#666600'>(</span><span style='color:#006666'>1</span><span style='color:#666600'>).</span>STX<span style='color:#666600'>),</span> <br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre> max<span style='color:#666600'>([</span>ogr_geometry<span style='color:#666600'>].</span><span style='color:#660066'>STPointN</span><span style='color:#666600'>(</span><span style='color:#006666'>1</span><span style='color:#666600'>).</span>STY<span style='color:#666600'>)</span><br><br><o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre><pre>FROM <span style='color:#666600'>[</span>TABLE<span style='color:#666600'>]</span><o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre><span style='font-family:"Arial","sans-serif"'>An entry in the table might look like:</span><o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre><o:p> </o:p></pre><pre><span style='font-family:"Arial","sans-serif"'><a href="http://i.imgur.com/gq8DayI.png" target="_blank">http://i.imgur.com/gq8DayI.png</a></span><o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre><span style='font-family:"Arial","sans-serif"'>Note: This will only work in the current dev version of QGIS.</span><o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre><span style='font-family:"Arial","sans-serif"'>- Nathan</span><o:p></o:p></pre><pre><span style='font-family:"Arial","sans-serif"'><br><br><o:p></o:p></span></pre><pre><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></pre></td></tr></table></div></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On Sat, Jun 29, 2013 at 12:00 AM, Steven Campbell <<a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Hi</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Does anyone else have significant time delays when trying to open large datasets from a SQL database in QGIS? I have uploaded my Ordnance survey MasterMap data (coverage is the size of an average English County) and although the initial connection to identify the table is very quick, the loading of the table (even when zoomed in to a very big scale (i.e. 1:100) it takes a very long time to open. Once opened the speed is very quick, but getting it to open takes a lot of patience as the application appears to hang.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>On a slightly related topic, if I have connected to one MSSQL database, QGIS then struggles if I try to connect to an additional database, again it just appears to hang for a considerable period of time (30 minutes or more at times), it seems odd especially as the connection to the first SQL database is almost instant....</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Any suggestions as to how I can improve this speed would be greatly appreciated.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Thanks</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Steve Campbell</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>GIS Manager</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Corporate Strategy and Communications</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Borough of Poole | Civic Centre | Poole BH15 2RU</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Tel: 01202 633 362</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Email: <a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-family:"Arial","sans-serif"'>Website:<a href="http://www.boroughofpoole.com/" target="_blank">www.boroughofpoole.com</a></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><i><span style='font-family:"Arial","sans-serif";color:#00B050'>Think Green! Please Recycle</span></i></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><p>DISCLAIMER:<br>This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. The copyright in all documentation is the property of the Borough of Poole and this email and any documentation must not be copied or used other than as strictly necessary for the purpose of this email, without prior written consent which may be subject to conditions. Any view or opinions presented are solely those of the author and do not necessarily represent those of the Borough of Poole. The Borough of Poole reserves the right to inspect incoming and outgoing emails. If you have received this email in error please contact the sender by return and confirm that its contents have been destroyed. Telephone enquiries should be directed to the Borough switchboard on 01202 633633.<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div></div></div><div><div><p>DISCLAIMER:<br>This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. The copyright in all documentation is the property of the Borough of Poole and this email and any documentation must not be copied or used other than as strictly necessary for the purpose of this email, without prior written consent which may be subject to conditions. Any view or opinions presented are solely those of the author and do not necessarily represent those of the Borough of Poole. The Borough of Poole reserves the right to inspect incoming and outgoing emails. If you have received this email in error please contact the sender by return and confirm that its contents have been destroyed. Telephone enquiries should be directed to the Borough switchboard on 01202 633633.<o:p></o:p></p></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div><p></p><p>DISCLAIMER:<br>This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. The copyright in all documentation is the property of the Borough of Poole and this email and any documentation must not be copied or used other than as strictly necessary for the purpose of this email, without prior written consent which may be subject to conditions. Any view or opinions presented are solely those of the author and do not necessarily represent those of the Borough of Poole. The Borough of Poole reserves the right to inspect incoming and outgoing emails. If you have received this email in error please contact the sender by return and confirm that its contents have been destroyed. Telephone enquiries should be directed to the Borough switchboard on 01202 633633.</body></html>