I am trying to use the geometry data types introduced in version 4.1-alpha
and the spatial indexing seems to work well. But I have a large volume of
data to load, and from the documentation all I can see is that I have to
load using a set of INSERT (or UPDATE) commands, which are rather verbose,
and which produce a lot of messages each time a row is inserted:
INSERT INTO tm VALUES
( 0.01082, 0.08536, 0.46,16.84,16.129,15.856,polygonfromtext('polygon( (0.00
999 0.08452, 0.01165 0.08452, 0.01165 0.08619, 0.00999 0.08619,
0.00999 0.08452))'));
I have made the inserts load many rows at a time, which helps a
little, but it is still slow. Does anyone know if there is a bulk load
format, suitable for use with LOAD DATA INFILE...
--
Clive Page,
Dept of Physics & Astronomy,
University of Leicester, UK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw