[GRASS-user] v.what.vect never ends, SQLite warning

Mehrdad Varedi varedi at gmail.com
Tue May 28 11:16:10 PDT 2019

Thank you, Markus, for sharing.

The link you send indicates that the SQLite supports up to 2000 columns and
the size can be 140TB. In my case, the number of columns was 60 that
majority of them had REAL types. It had around 250K rows. My guess is that
it is not the SQLite issue and something in between causes the problem.
Maybe something on my computer or the way GRASS interacts with SQLite
(probably some setting such as buffer size, on my computer etc. might be an

If you are aware of any settings that I could play with, please let me know
to speed up (read/write or Import / export) of layers in GRASS.

Kind regards,



On Tue, May 28, 2019 at 1:51 PM Markus Neteler <neteler at osgeo.org> wrote:

> Hi
> Mehrdad Varedi <varedi at gmail.com> schrieb am Di., 28. Mai 2019, 19:38:
>> Subject: Re: [GRASS-user] v.what.vect never ends, SQLite warning
>> Hi Everyone,
>> I think I figured out the problem.
>> I found that the problem was only the size or number of attributes in the
>> point layer when I dropped and reduced the attributes it worked very fast
>> and with no problem.
>> I am interested to know the limitations in GRASS GIS in terms of the
>> number of features or attributes, if there is any reference, please let me
>> know.
> Yes, please see
> https://grasswiki.osgeo.org/wiki/GRASS_GIS_Performance#Vector_management
> Best
> Markus

Mehrdad Varedi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20190528/c0867ff0/attachment.html>

More information about the grass-user mailing list