RE: [MySQL] Re: Variables in stored procedures

2010-05-01 Thread Ashley M. Kirchner
Huh? That doesn't make a whole lot of sense. If that is the case, can you explain why? Is the stored procedure mechanism that primitive? From: Ted Yu [mailto:yuzhih...@gmail.com] Sent: Saturday, May 01, 2010 7:11 AM To: Ashley M. Kirchner Subject: Re: [MySQL] Re: Variables in stored

Re: Best index for searching on lat / long data i.e. decimal vs. float

2010-05-01 Thread dan
On Sat, 01 May 2010 15:28:46 -0500, mos mo...@fastmail.fm wrote: SELECT * FROM `grid`� force index(section) WHERE n 49.012 AND s 49.012 AND e 110.0244 AND w 110.0244; It should give you the answer around 0.1 seconds. Give it a try. :-) Mike It actually makes it worse