<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:verdana,helvetica,sans-serif;font-size:10pt"><div>Hi Moritz,<br><br>Thanks for responding. <br><br>>Which backend are you using ? <br><br>Backend is currently dbf (default). Is there a preferred option for speeding up this type of query?<br><br>>Which process is running during all this time ?<br><br>Not sure exactly which process is running. I did --verbose but the chat stopped after the "excluding x points outside region" message. Any tips on how to tell which point it is sticking at would be gratefully received!<br><br>>The module executes each individual update query one at a time. Maybe it
might be more efficient >to group them into a temporary file with the
SQL statements and then run that all at once?<br><br>Sounds good but I have no idea how to do this - can you point me in the direction of some more info so that I could try this method?<br><br>Many thanks,<br>Rebecca<br><br></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Moritz Lennert <mlennert@club.worldonline.be><br><b><span style="font-weight: bold;">To:</span></b> Rebecca Bennett <rabennett@ymail.com><br><b><span style="font-weight: bold;">Cc:</span></b> grass list <grass-user@lists.osgeo.org>; grass-dev <grass-dev@lists.osgeo.org><br><b><span style="font-weight: bold;">Sent:</span></b> Mon, 2 May, 2011 10:00:41<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [GRASS-user] Maximum number of points for
v.what.rast<br></font><br>On 30/04/11 21:50, Rebecca Bennett wrote:<br>> hello there,<br>> <br>> Does anyone know the maximum number of points that v.what.rast can handle?<br>> I have a file of 600,000+ points that fails to run (12hrs 100% CPU and<br>> nothing) and I wonder, before I start with trial and error, if anyone<br>> knows the answer?<br><br>There is no fixed maximum number of points. My guess would be that the time needed really depends on the database backend and whether there is an index on the category column.<br><br>Which backend are you using ? Which process is running during all this time ?<br><br><br><br>Moritz<br></div></div>
</div></body></html>