MySQL Forums
Forum List  »  GIS

Re: very slow insert, very large iowait
Posted by: Jean-Paul Le Fèvre
Date: June 10, 2005 05:36PM

No :(
Actually I found that the problem is due to the spatial index.
The regular indexes behave as expected.

In the mysql world not many people are interested in spatial features so it's hard to figure out what to do.

I've moved to Oracle to compare and it happens that the problem is worse ! It takes day(s) to synchronize the spatial index ! But I'm a kind of newbie as far as Oracle is concerned and It's likely a configuration problem.

Still working ....

Options: ReplyQuote

Written By
June 10, 2005 12:10PM
Re: very slow insert, very large iowait
June 10, 2005 05:36PM
November 25, 2005 09:35AM

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.