Re: how dod you get to do multiple mysql queries concurrently?
| From: | Zoltán Németh | Date: | Fri, 01 Feb 2008 10:00:28 +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 12 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268525@lists.php.net to get a copy of this message | ||
2008. 02. 1, péntek keltezéssel 11.55-kor Paul Scott ezt írta:
> 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 :(
sure I got it but answered before I reached it in reading. sorry for the
noise.
as for the GEOS stuff I think I'll do some research on it, it sounds
very interesting
greets
Zoltán Németh
>
> --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
> 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