<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
On 07/24/2012 03:10 PM, Zoltan Szecsei wrote:
<blockquote cite="mid:500E90D3.6090206@geograph.co.za" type="cite">Hi,
<br>
I have a SHP file of some 1.1m polygons, of which I need to select
about half of them, and save them as a separate SHP file.
<br>
<br>
The trouble is when I select either via a Query, or via the TABLE
using the select options below, it just falls asleep (100% CPU
(ok, 12% as it must be single-threaded)).
<br>
After 45 minutes or so, I just kick it out and weep.
<br>
<br>
My platform is Win 7 Prof 64 bit (also tried on 32 bit) and using
1.8.0 Lisboa.
<br>
<br>
The selects I have tried are: "sq21code" = "C016*" and also
tried using "IN"
<br>
<br>
Any ideas what I am doing wrong and what I should try next?
<br>
<br>
</blockquote>
<br>
In addition to Andre's correction about the * wildcard, with 1M
polygons, you probably should move the shapefile into a database
(i.e spatialite, PostGIS)<br>
<br>
<blockquote cite="mid:500E90D3.6090206@geograph.co.za" type="cite">Thanks
& regards,
<br>
Zoltan
<br>
<br>
<br>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consultant, Arava Development Co.
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a></pre>
</body>
</html>