On Tue, Feb 5, 2013 at 8:25 PM, Camilo III Lozano <[email protected]>wrote:
> ako gi research ang spatial... naa pa sya... murag di man maapply.. or di > lang ko kabalo cguro. hahahaha... well, some theory: indexes uses b-trees wc does exact search. however, betweeness scans ranges, ergo standard sql optimizer (no matter how you index) do not apply. you may need at least an r-tree wc spatial index provides. non-theory: testingi lang. my take is: walay "di lang ko kabalo" for camilo the hacker.. in the meantime, try also using the query cache para ka tabang gamay... best regards -botp ps: testing experience only on postgresql and postgis. so you'll have to test it on your side for mysql...
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://lists.linux.org.ph/mailman/listinfo/klug) Searchable Archives: http://archives.free.net.ph
