[GRASS-dev] [GRASS GIS] #1744: v.out.ascii: export all columns

[GRASS GIS]

#1744: v.out.ascii: export all columns
----------------------------------+-----------------------------------------
 Reporter:  lucadelu              |       Owner:  martinl  
     Type:  enhancement           |      Status:  assigned 
 Priority:  normal                |   Milestone:  7.0.0    
Component:  Vector                |     Version:  svn-trunk
 Keywords:  v.out.ascii, columns  |    Platform:  All      
      Cpu:  Unspecified           |  
----------------------------------+-----------------------------------------

Comment(by martinl):

 Replying to [comment:5 hamish]:

 > did v.out.ascii columns= ever get fast?

 {{{
 v.info n1 -t
 points=100000

 v.db.connect n1 -g
 1/n1|n1|cat|/home/martin/grassdata/nc_spm_08/user1/sqlite/sqlite.db|sqlite
 }}}

 {{{
 time v.out.ascii n1 out=n1-nocols --o

 real    0m0.305s
 user    0m0.288s
 sys     0m0.012s

 time v.out.ascii n1 out=n1-cols columns=* --o
 real    0m56.643s
 user    0m32.658s
 sys     0m28.166s
 }}}

 Could be probably optimized.

 > It used to be unusably slow when there was > ~10000 db rows since it was
 opening and closing the db for every entry. I have a vague recollection
 that MarkusM commented at some point that

 DB is open once [source:grass/trunk/lib/vector/Vlib/ascii.c#L378]. For
 every feature is open select cursor
 [source:grass/trunk/lib/vector/Vlib/ascii.c#L639].

 Martin

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/1744#comment:7>
GRASS GIS <http://grass.osgeo.org>