Re: how dod you get to do multiple mysql queries concurrently?
| From: | Per Jessen | Date: | Mon, 28 Jan 2008 18:37:35 +0000 |
| Subject: | Re: how dod you get to do multiple mysql queries concurrently? | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268222@lists.php.net to get a copy of this message | ||
Richard Lynch wrote:
> On Sat, January 26, 2008 3:45 am, Per Jessen wrote:
>> Nathan Rixham wrote:
>>
>>>Back on the mysql side of things, try using geometry columns rather
>>>than numerical primary keys, with spatial indexes.. it's a MASSIVE
>>>performance upgrade (I've cut 5 second queries down to 0.005 by using
>>>geo columns)
>>
>> Uh, could you could elaborate a bit on that (whilst I go and do some
>> googling)?
>
> If you are doing geography/geometry stuff, spatial indices can be
> nice.
>
OK, what is a 'geometry column' and what is a 'spatial index' ?
/Per Jessen, Zürich