<br><tt><font size=2>Hi Jon,</font></tt><br><br><tt><font size=2>I am from Ritesh team. We are getting around 2 secs
average response time for analysis in Oracle routing . I am in process
of fine tuning like incorporating link level preference, fine tuning
the partition size, connected components. I was also thinking of precaching
the results(may be with xml) if it is available. Have you used any precaching
also? </font></tt><br><br><tt><font size=2>Regards</font></tt><br><tt><font size=2>Gagan</font></tt><br><br><br><table width=100%><tr valign=top><td width=40%><font size=1 face="sans-serif"><b>Jon Scarbrough <jscarbrough@where2getit.com></b></font><br><font size=1 face="sans-serif">Sent by: mapserver-users-bounces@lists.osgeo.org</font><p><font size=1 face="sans-serif">05/03/2008 03:24 AM</font><td width=59%><table width=100%><tr valign=top><td><div align=right><font size=1 face="sans-serif">To</font></div><td><font size=1 face="sans-serif">riteshambastha <ritesh.linux@gmail.com></font><tr valign=top><td><div align=right><font size=1 face="sans-serif">cc</font></div><td><font size=1 face="sans-serif">mapserver-users@lists.osgeo.org</font><tr valign=top><td><div align=right><font size=1 face="sans-serif">Subject</font></div><td><font size=1 face="sans-serif">Re: [MAPSERVER-USERS] Any other Routing
solution than pgRouting/Oracle NDM ?</font></table><br><table><tr valign=top><td><td></table><br></table><br><br><br><tt><font size=2>Ritesh,<br><br>I need to weigh in little bit since we are using the Oracle <br>Geocoder/Routeserver in conjunction with the Navteq data set. Our
<br>experience is that on a well tuned Oracle appserver/db cluster, an <br>normal route will calculate in about .5 secs. But, there is a lot of <br>tuning to get your java engine properly configured to deal with garbage
<br>collection and you must have enough memory to hold sufficient partitions
<br>in memory so you don't have to go back to disk.<br><br>We then take the Oracle route response and convert it to xml that is <br>sent back to the browser and have Openlayers lay it on the map using <br>SVG/VML. The biggest amount of time is spent parsing the XML and <br>creating the SVG. There are a lot of moving parts and as Steve <br>mentioned, you need to measure each part (route server, web server <br>handling the conversion of route response to the browser, Openlayers <br>layer manipulation).<br><br>In my experience, the Oracle router is not the bottleneck.<br><br>Thanks.<br><br>Jon Scarbrough<br>Where2GetIt.com<br><br><br>riteshambastha wrote:<br>> Thanks Steve, <br>><br>> I am pretty sure your words are making a mapserver enthusiast's life
very<br>> easy. <br>><br>> For Route computation I am using a licensed version of Oracle Spatial
DB.<br>> Now, as PostGIS is looking so promising in the market, I am also thinking
to<br>> shift to PostGIS. <br>><br>> And after that, I will re-engineer my routing code using : <br>> <br>>> pgRouting<br>>> Ka-map xmlOverlay<br>>> <br>><br>> I guess I am going in the right direction.<br>><br>> Regards,<br>> Ritesh Ambastha<br>><br>><br>><br>> Stephen Woodbridge wrote:<br>> <br>>> riteshambastha wrote:<br>>> <br>>>> Thanks Steve,<br>>>><br>>>> Route computation is taking an average time of 1.2 sec.<br>>>> Post this, showing route on the browser takes a lot of time.
<br>>>> I am not using kamap xml overlay and any lib of openlayers.
<br>>>><br>>>> I am posting this route result xml into a db, and allowing
a map file to<br>>>> read this db and show the route on map.<br>>>> I know this is not an efficient way to do the job. <br>>>> <br>>> I would start by adding some timing to a log file so you KNOW
where your <br>>> time is getting spent, then work on optimizing the larger times.<br>>><br>>> I think this is the fastest way to go unless the route is relatively
<br>>> small in the number of nodes in the polyline. You should look
at getting <br>>> rid of the xml, in fact, why are you going to xml at all and then
<br>>> putting it back into the database. The data is being generate
in the <br>>> database then you extract it and format it into xml and then put
the xml <br>>> back into the database for mapserver to pick up. I think you should
just <br>>> put it into a table of routes with a unique sessionid+routeid
key then <br>>> pass the key to mapserver to use on selecting the right record.<br>>><br>>> <br>>>> I got to know that openlayers libs can help me to achieve
the same. I<br>>>> want<br>>>> to know how in-efficient will be to use kamap xml overlay
instead of any<br>>>> fn<br>>>> of openlayers.<br>>>> <br>>> You can server the route as a wfs layer, but if it is complicated
it <br>>> might be too many points to handle quickly in the browser.<br>>><br>>> -Steve<br>>><br>>> <br>>>> Regards,<br>>>> Ritesh Ambastha<br>>>><br>>>> Stephen Woodbridge wrote:<br>>>> <br>>>>> riteshambastha wrote:<br>>>>> <br>>>>>> Dear friends, <br>>>>>><br>>>>>> I have seen routing based on postgis routing and oracle
network data<br>>>>>> models.<br>>>>>> Even though, they serve the purpose very efficiently,
they take some<br>>>>>> 1sec/2sec/3sec to display the routes. I checked them
with OpenLayers<br>>>>>> and<br>>>>>> Ka-map. Still, I feel there must be a way to reduce
this route display<br>>>>>> time.<br>>>>>> Is there any any other ways to show routing/directions
over mapserver<br>>>>>> based<br>>>>>> maps? Any other data structure and programming in
C/python can serve<br>>>>>> the<br>>>>>> purpose ?<br>>>>>> <br>>>>> What is taking too long?<br>>>>> 1) is it the route computation<br>>>>> 2) transfering the route data to OpenLayers<br>>>>> 3) rendering the route data as a vector layer<br>>>>><br>>>>> Have you considered writing some code on the server that
generates an <br>>>>> image file from the route data and returns a url for the
image that can <br>>>>> be then pinned to OpenLayers like a marker? You could
do this by writing <br>>>>> a wrapper in your favorite scripting language around the
request to <br>>>>> generate the route.<br>>>>><br>>>>> -Steve W<br>>>>> _______________________________________________<br>>>>> mapserver-users mailing list<br>>>>> mapserver-users@lists.osgeo.org<br>>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>>>>><br>>>>><br>>>>> <br>>> _______________________________________________<br>>> mapserver-users mailing list<br>>> mapserver-users@lists.osgeo.org<br>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>>><br>>><br>>> <br>><br>> <br>_______________________________________________<br>mapserver-users mailing list<br>mapserver-users@lists.osgeo.org<br>http://lists.osgeo.org/mailman/listinfo/mapserver-users<br></font></tt><br><BR>
<BR>
<BR>
The information contained in this e-mail message is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you should return it to the sender immediately. Please note that while we scan all e-mails for viruses we cannot guarantee that any e-mail is virus-free and accept no liability for any damage caused by any virus transmitted by this email.<BR>