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

[Ben Johansen]

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