Re: Witango-Talk: Distance Calculations - Sort on..., search on...

[[EMAIL PROTECTED]]

Ben,   the calculation for the distance is very fast, it will be done on the flight. But thx for the suggestion with the server side script. This will be faster....   rs   Daniel ----- Original Message ----- From: Ben Johansen To: [EMAIL PROTECTED] Sent: Sunday, October 31, 2004 9:34 PM Subject: RE: Witango-Talk: Distance Calculations - Sort on..., search on... Have you thought of sever side scripting?   I did a similar test a while back where the array was passed into server side _javascript_ and it did the calcs very fast   <@SCRIPT EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 'Adressen.Geo_Breite'>)*COS(<@COLUMN 'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388”>   Just a thought   Ben     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 10:23 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Distance Calculations - Sort on..., search on...   Distance Calculation is no problem, that works. Here the formula: <@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 'Adressen.Geo_Breite'>)*COS(<@COLUMN 'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">   The problem what I have is:   1) To do a sort of the result (OK, I can do it in a array, but this need to much RAM [more as 2500 records, nearly 50x on one time])   2) To do a search in a specified area like "show me all points near x miles(km).   One way what make sense is to store the formula in the database, but - if i make a assign to a variable, then Witango store only the result. What I like to store is the formula-text:     Second problem: I can't do a sort on the stored formula (Sort command: <@COLUMN 'Adressen.formel' Encoding="Metahtml">)   Any Successions ?   THX for help   regards Daniel   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf