Camilord, sql will be slow in the long run. My recommendation is use caching technology. The idea is first-time will be slow even with all the indexing, second time will be a lot more faster due to caching...
Regards, Paul On Wed, Feb 6, 2013 at 7:26 AM, botp <[email protected]> wrote: > 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 > -- Paul Labis Senior Software Engineer www.paullabis.com | www.feedmoko.com If there is a will, there is a way! Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by it.
_________________________________________________ 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
