I have a database which is in InnoDB, because I wanted consistency (cascading delete).
Now, I want to use spatial indexes for selecting rows ordered by geometric distance.
However, spatial indexes require MyISAM. What is the best thing to do?
The best I could think of is to put the location in a separate MyISAM table and join the InnoDB table with it? (Note that I have removed the spatial magic from the statement to simplify things.)
select * from inno join isam using (id) order by isam.distance