<div dir="ltr">Hi Markus,<div><br></div><div>I tried the db.connect -p and found that the database driver is SQLite.</div><div><br></div><div><div>(Thu May 31 10:53:07 2018) </div><div>db.connect -p </div><div>driver: sqlite</div><div>database: F:\Projects-Analysis\GRASSData\SWOntarioTestSites\Waterlix\sqlite\sqlite.db</div><div>schema: </div><div>group: </div><div>(Thu May 31 10:53:07 2018) Command finished (0 sec) </div><div><br></div><div>Does anything else cause the issue? </div><div><br></div><div>Thanks for your help.</div><div><br></div><div>Mehrdad </div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 31, 2018 at 9:13 AM, Markus Metz <span dir="ltr"><<a href="mailto:markus.metz.giswork@gmail.com" target="_blank">markus.metz.giswork@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span class=""><br><br>On Wed, May 30, 2018 at 11:50 PM, Mehrdad Varedi <<a href="mailto:varedi@gmail.com" target="_blank">varedi@gmail.com</a>> wrote:<br>><br>> Hi Everyone,<br>><br>> When using v.color on a map with 2 Million points, it takes more than 24 hours (I guess the last time it took near 40 hours). The CPU is busy less than 20% on a 8 core machine and a lot of memory is available (50% at least is empty out of the 16 GB). Is there a way that I could accelerate the processing? Is it normal at all?<br><div><br></div></span><div>A reason could be that the vector uses dbf as database driver. Database drivers other than dbf can make use of an index, therefore you could verify the database driver for WM195 with v.db.connect -p</div><div><br></div><div>If the vector uses dbf, you can switch to the default sqlite driver with</div><div><br></div><div>db.connect -d</div><div><br></div><div>then verify with db.connect -p</div><div><br></div><div>now make a copy of the vector and try again v.colors.</div><div><br></div><div>HTH,</div><div><br></div><div>Markus M</div><span class=""><div><br></div><div><br></div><div>></div>> Here is the command I am using:<br>><br>> v.colors -c --verbose map=WM195@Waterlix use=attr column=BRProbH color=gyr rgb_column=ColorH<br>><br>> Thanks for your help in advance,<br>><br>><br>> Mehrdad<br>><br>> --<br>> Mehrdad Varedi<br>><br>><br></span>> ______________________________<wbr>_________________<br>> grass-user mailing list<br>> <a href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a><br>> <a href="https://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/grass-user</a><br><br></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Mehrdad Varedi</div>
</div>