Skip to main content
1 of 2
JohnP
  • 491
  • 3
  • 12

Using MyIsam is probably your best and only bet to be able to use a spatial index. You might consider storing the data in an innodb table and then export data continuously or by batch, according to your needs, to a myisam table. Then use the myisam table for your queries.

I wouldn't trust myisam as storage engone if data is of importance.

Seems like you figured out the solution yourself.

JohnP
  • 491
  • 3
  • 12