Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Say I want 20 closest businesses to a location.

Innodb doesn't support that. So what does?

Is it possible to have some tables in some engine and other tables on different engines?

share|improve this question
Not sure if this is geo-ip related or a general mapping question. If the former this might be relevant dbasquare.com/2012/06/01/… – atxdba Jun 12 '12 at 4:44
And yes, you can have varying storage engines per table in a given mysql database – atxdba Jun 12 '12 at 4:45

2 Answers

up vote 1 down vote accepted

Yes you can use MyISAM for storing the geo location as they support the spatial data types.For more information please look Saptial Datatypes in MySQL

And You can also use the mix of engines there is no issues on that..

share|improve this answer
No issues? What about Foreign Keys? – ypercube Jun 14 '12 at 0:03
up vote 1 down vote

Here is how to design an optimal schema, plus code, to find the 20 closest whatevers:

http://mysql.rjweb.org/doc.php/latlng

share|improve this answer
How does this compare to spatial indexes? Pros and cons? – ypercube Jun 14 '12 at 0:02
I have not benchmarked. Mine is Order(1), so you can't get faster. – Rick James Sep 5 '12 at 21:22
I somehow find this claim hard to believe, without benchmarks. – ypercube Sep 5 '12 at 21:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.