@alfredo: hmmm.. di man necessary ang city sa query.. ang need kay ang startIpNum and endIpNum ... so ako gi index ang duwa... but mo take gihapon ug almost a second or more...
===================== On Wed, Feb 6, 2013 at 1:25 AM, 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... > > =============== > > On Wed, Feb 6, 2013 at 12:01 AM, botp <[email protected]> wrote: > >> oops again. >> >> 1 didnt know there is spatial indexing in mysql.. until now.. >> 2 do not know mysql here, so shutting my mouth now : - ) >> >> kind regards -botp >> >> >> >> On Tue, Feb 5, 2013 at 6:37 PM, botp <[email protected]> wrote: >> >>> oops, ignore. mysql man diay. >>> >>> >>> On Tue, Feb 5, 2013 at 6:33 PM, botp <[email protected]> wrote: >>> >>>> On Tue, Feb 5, 2013 at 1:20 PM, Camilo III Lozano >>>> <[email protected]>wrote: >>>> >>>>> any suggestion to make it faster? thanks advance... >>>>> >>>> >>>> the "between"ess is in question. definitely, you'd need a spatial index. >>>> >>>> best regards -botp >>>> >>>> >>> >> >> _________________________________________________ >> 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 >> > > > > -- > ================== > NZ Mobile: +64 22 159 5396 > NZ Telephone: 04 977 9378 > PH Mobile #: +63916-3338326 > PH Telephone #: (+63)(63) 221-1122 > > *Personal Projects* > > - http://www.prendstah.com > - http://www.kagayan.com > - http://www.zabyer.org > - http://www.omarket.co.nz > - http://www.larn.me > - http://www.seofart.com > > > -- > Registered Linux User: #439468 > > > > > -- ================== NZ Mobile: +64 22 159 5396 NZ Telephone: 04 977 9378 PH Mobile #: +63916-3338326 PH Telephone #: (+63)(63) 221-1122 *Personal Projects* - http://www.prendstah.com - http://www.kagayan.com - http://www.zabyer.org - http://www.omarket.co.nz - http://www.larn.me - http://www.seofart.com -- Registered Linux User: #439468
_________________________________________________ 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
