On Fri, February 1, 2008 3:55 am, Paul Scott wrote:
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 :(
I got the email below, and it made perfect sense...
Though I am not sure it would make sense to
On Sun, February 3, 2008 6:08 pm, Jochem Maas wrote:
of paginated data combined with user defined filters (e.g. a product
list sorted by price, etc and filter on type/category/keyword/etc)
If you want GIS to be useful for that, you'd have to pretend that
something like type was, say, longitude,
On Tue, 2008-02-05 at 11:53 -0600, Richard Lynch wrote:
This is actually pretty OT for the PHP list itself, really, unless you
want to try to implement GIS in PHP, which would be a particularly Bad
Idea (tm) due to the scale, scope, and calculations involved.
Err, sorry, but I must correct
On Mon, 2008-02-04 at 01:08 +0100, Jochem Maas wrote:
the column spec. what kind of geomtery column is it? and
A geographical geometry i.e. a projected data set of Geo data.
are you using it as a primary key? or some else
No, the integer gid is usually a primary key still. The geo data is
Paul Scott schreef:
Did anyone actually get this mail?
it came through :-)
More concrete example? What would you like to see?
the column spec. what kind of geomtery column is it? and
are you using it as a primary key? or some else ... if so what kind
of stuff are you storing in there?
2008. 02. 1, péntek keltezéssel 03.40-kor Jochem Maas ezt írta:
Per Jessen schreef:
Richard Lynch wrote:
OK, what is a 'geometry column' and what is a 'spatial index' ?
Imagine a single column combining both longitude and latitude.
Now imagine an index that knows about long/lat, and
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
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
Per Jessen schreef:
Richard Lynch wrote:
OK, what is a 'geometry column' and what is a 'spatial index' ?
Imagine a single column combining both longitude and latitude.
Now imagine an index that knows about long/lat, and keeps
geographically close objects sorted in the index for you.
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
On Mon, January 28, 2008 12:37 pm, Per Jessen wrote:
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
Richard Lynch wrote:
OK, what is a 'geometry column' and what is a 'spatial index' ?
Imagine a single column combining both longitude and latitude.
Now imagine an index that knows about long/lat, and keeps
geographically close objects sorted in the index for you.
Including knowing
On Mon, 2008-01-28 at 12:29 -0600, Richard Lynch 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
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
Richard Lynch wrote:
When you create a cursor, it's like a handle to a running query in the
background process, and returns immediately.
Create three cursors, and you SHOULD have them running in parallel.
Ah, I see. Hmm, interesting idea. Although it won't be much good as
I'm not actually
On Sat, January 26, 2008 3:45 am, Per Jessen wrote:
Nathan Rixham wrote:
I posted you a short script on this thread at 04:07 GMT today
that'll
get you multithreading (via cli) - but even then you can shell exec
that cli script from apache..
Yeah, I noticed, thanks. The thing is - once
On Sat, January 26, 2008 3:17 am, Per Jessen wrote:
Richard Lynch wrote:
On Fri, January 25, 2008 3:35 am, Per Jessen wrote:
I have a website where some of the pages require several mysql
queries -
they're independent, so in principle they could easily be run in
parallel. Has anyone looked
I posted you a short script on this thread at 04:07 GMT today that'll
get you multithreading (via cli) - but even then you can shell exec that
cli script from apache..
Per Jessen wrote:
Richard Lynch wrote:
On Fri, January 25, 2008 3:35 am, Per Jessen wrote:
I have a website where some of
Nathan Rixham wrote:
I posted you a short script on this thread at 04:07 GMT today that'll
get you multithreading (via cli) - but even then you can shell exec
that cli script from apache..
Yeah, I noticed, thanks. The thing is - once pcntl_fork() is added to
the mix, it's getting a little
Richard Lynch wrote:
On Fri, January 25, 2008 3:35 am, Per Jessen wrote:
I have a website where some of the pages require several mysql
queries -
they're independent, so in principle they could easily be run in
parallel. Has anyone looked at doing that?
If MySQL has implemented cursors
All,
I have a website where some of the pages require several mysql queries -
they're independent, so in principle they could easily be run in
parallel. Has anyone looked at doing that?
/Per Jessen, Zürich
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Fri, January 25, 2008 3:35 am, Per Jessen wrote:
I have a website where some of the pages require several mysql queries
-
they're independent, so in principle they could easily be run in
parallel. Has anyone looked at doing that?
If MySQL has implemented cursors in some new version, you
22 matches
Mail list logo
