spatial boundaries: aka polygons, the zones you referred to spatial queries are super quick if you use MBR's (squares) but if you are using suburb or other types of polygons, it slows down
On Wed, Sep 5, 2012 at 2:00 PM, Claude Raiola <[email protected]> wrote: > Hi Zac > > You lost me with the comment re how dense the spatial boundaries are ??? > > The devices send to the server a text string containing all the relevant > data, each piece of data comma separated an example being > > +RESP:GTSOS,010000,861785008785465,TCSOSV,,,1,10,0.0,0,0,153.035933,-27.4716 > 69,20120806111126,505,003,0FB9,B339,00,27,505,003,0FB9,B33A,20120806203133,0 > 003$ > > The above being an example of the data sent from the device to the server > representing one location event. > > Naturally the manufacture provides a scheme in order to be able to defined > what each value in the string represents > > My underlying concern is how the socket will handle lets same 100 packets of > data received from 100 different devices simultaneously or within seconds of > each other > > Regards > > Claude Raiola (B.Econ Acc; B.Hot. Mngt) > Samaris Software > Email: [email protected] > Website: www.SAMARIS.net > Mobile: 0414 228 948 > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Zac Spitzer > Sent: Wednesday, 5 September 2012 12:49 PM > To: [email protected] > Subject: Re: [cfaussie] CF Socket / Listener > > there's nothing really different about load when using cfsocket or using a > normal webpage > > you just need to setup your app with processing and then load test, by using > cfsocket, it's going to be a bit harder than using good old http, as I'm not > sure if something like JMeter supports sockets > > as far as it goes for spatial processing, the biggest issue problem will be > how dense your spatial boundaries are, if they are simple and coarse, they > will be fast, but if they are denser, each request they will slow down - > PostGIS is the fastest > > it's probably best to have two processes, one which receives and records > them and another which processes in batches that data > > having no indexes on the incoming table will make receiving a lot faster > > On Thu, Aug 30, 2012 at 6:57 PM, Claude Raiola <[email protected]> > wrote: >> Hi Zac, >> >> The data needs to be processed as it is received as the information >> relates the locations of people, the data being transmitted from >> mobile gps personal location devices, which report their location at >> set intervals >> >> The information often needs to be validated against specific sets of >> gps co ordinates to allow for the portal to test whether the personal >> location device is within pre determined zones or else outside of the >> zones and depending on the answer processes and alerts may been to be >> triggered as a result >> >> So in short it needs to be in real time with a slight allowance for >> processing time, this allowance needs to be less than 120 seconds >> >> >> Regards >> >> Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software >> Email: [email protected] >> Website: www.SAMARIS.net >> Mobile: 0414 228 948 >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] On >> Behalf Of Zac Spitzer >> Sent: Thursday, 30 August 2012 4:28 PM >> To: [email protected] >> Subject: Re: [cfaussie] CF Socket / Listener >> >> do you need to process them in realtime, or can you simply receive and >> put them into a queue to be processed? >> >> On Thu, Aug 30, 2012 at 4:23 PM, Claude Raiola <[email protected]> >> wrote: >>> Hi, >>> >>> >>> >>> Just wondering how I would go about creating a Listener with my cf >>> application using CFSocket however it needs to be robust enough to >>> ensure that it could handle potentially 100's off different data sets >>> send to it every minute at times of peak load without any data sets >>> being lost, broken or causing the function to lock up. >>> >>> >>> >>> The data will be sent by remote devices over gprs and the packets >>> will be in either tcp or UDP format >>> >>> >>> >>> >>> >>> Regards Claude >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "cfaussie" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/cfaussie?hl=en. >> >> >> >> -- >> Zac Spitzer >> Solution Architect / Director >> Ennoble Consultancy Australia >> +61 405 847 168 >> >> -- >> You received this message because you are subscribed to the Google >> Groups "cfaussie" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/cfaussie?hl=en. >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups > "cfaussie" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to > [email protected]. >> For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. >> > > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > +61 405 847 168 > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
