2 days needed to build a spatial index !
I'm working with a table which has about 25 millions rows.
One of the column in this table is of type geometry point.
To build a spatial index on such a table it takes more than
2 days !
Other indexes are rebuilt in less than 1 hour.
The server is running on 4 cpu machine 2.5 GHz, 2Gb RAM.
The MySQL version is 5.0.4.
I've tested a lot of various configuration parameters but
without any noticeable improvement.
What bothers me is that the cpu are used at less than 1% and that
they spend most of the time waiting for the IO.
Ideas welcomed !
Subject
Views
Written By
Posted
2 days needed to build a spatial index !
2073
June 27, 2005 10:21AM
1494
July 21, 2005 01:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.