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 <[EMAIL PROTECTED]> 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 _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
