[GRASS-dev] DBMI driver speed test

[Markus Neteler]

Hi,

I have made a speed comparison (also to test functionality,
see below) of the DBMI drivers:

# North Carolina Location
# the copy job:
START=`date` ;  for i in `g.mlist type=vect map=PERMANENT` ; do echo
"------ $i:" ; g.copy vect=$i,my$i --o ; done ; echo $START ; date

# Results:
SQLite driver (reading from DBF):
Sun Jun 15 11:10:41 CEST 2008
Sun Jun 15 11:12:02 CEST 2008
-> 1.350000min

PostgreSQL (reading from DBF):
Sun Jun 15 11:12:10 CEST 2008
Sun Jun 15 11:14:15 CEST 2008
-> 2.083333min

DBF (reading from DBF):
Sun Jun 15 11:16:29 CEST 2008
Sun Jun 15 11:17:49 CEST 2008
-> 1.333333min

DBF (reading from SQLite):
Sun Jun 15 11:23:20 CEST 2008
Sun Jun 15 11:24:49 CEST 2008
-> 1.483333min

MySQL (reading from DBF):
Sun Jun 15 11:42:44 CEST 2008
Sun Jun 15 11:44:12 CEST 2008
-> 1.466667min (but 4 tables not copied)

The mysql driver had some problems
* http://trac.osgeo.org/grass/ticket/188
* this one (reserved word as column name?):

elev_lidrural_mrpts:
Copy vector <elev_lidrural_mrpts at PERMANENT> to current mapset as
<myelev_lidrural_mrpts>
WARNING: Vector map <myelev_lidrural_mrpts> already exists and will be
         overwritten
WARNING: Table <myelev_lidrural_mrpts> linked to vector map
         <myelev_lidrural_mrpts> does not exist
DBMI-MySQL driver error:
Cannot create table:
CREATE TABLE myelev_lidrural_mrpts ( cat INT, Class INT, Layer INT, Return INT )
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'Return INT )' at line 1

Not sure what's wrong here.

Markus