Re: how dod you get to do multiple mysql queries concurrently?
| From: | Paul Scott | Date: | Fri, 01 Feb 2008 09:55:54 +0000 |
| Subject: | Re: how dod you get to do multiple mysql queries concurrently? | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268524@lists.php.net to get a copy of this message | ||
Did anyone actually get this mail?
More concrete example? What would you like to see?
I suspect that some of my mail is getting dropped :(
--Paul
On Fri, 2008-02-01 at 06:33 +0200, Paul Scott wrote:
> On Fri, 2008-02-01 at 03:40 +0100, Jochem Maas wrote:
>
> > I for one would really like to see a concrete example of this kind of
> > use of geometry columns and spacial indexes as an alternative to the stand
> > integer based primary keys.
>
>
> On one of my local postGIS tables:
>
> CREATE INDEX k1
> ON kanagawa
> USING gist
> (the_geom);
>
>
> A gist index is a GEOS based spatial index. You will need GEOS to create
> one.
>
> When loading spatial data, your geometry column looks like so:
>
>
> 01050000000100000001020000000C00000011ECE564CF7561404A8999CCDABC4140E5C0981ACE75614012901CD641BD4140603C8386BE756140E525611B40BD41405BF216D3BD756140151DC9E53FBD414054DC1A4DBD756140760B997A3FBD414012219BD1BC756140D20823E33EBD41407AB2884EBC7561400F2110243EBD41404571B4D0BB756140CC0C6A213DBD4140F707192ABB7561405DF2A1803CBD4140F0F11CA4BA756140C3D1B7413CBD4140E89CB2ADB97561406F046D233CBD414017D4B7CCA97561406D47AD7F39BD4140
>
> Which is WKB (Well Known Binary) data or WKT (Well Known Text) data. The
> gist index simply indexes this as opposed to the regular gid (which you
> still use btree indexes on anyways)
>
> --Paul
>
> All Email originating from UWC is covered by disclaimer
>
> http://www.uwc.ac.za/portal/public/portal_services/disclaimer.htm
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
------------------------------------------------------------.
| Chisimba PHP5 Framework - http://avoir.uwc.ac.za |
:------------------------------------------------------------: