Hi,The postgres option is a great one. One of our tables is currently holding 140 million rows and we get sub second response from it.I have been told that mySQL 5 is really good. It is also suppoed t be the speed champion.
Cheers,Simon HaddonOn 13/11/06, Toby Tremayne [EMAIL PROTECTED] wrote:
I'd
What about disabling the Flex Builder plugin? You can go to Help
Software Updates Manage Configuration and disable it from there.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this
See:
http://www.actcfug.com/index.cfm?fuseaction=NewsViewNewsID=295
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe
I am able to retrieve surrounding suburbs with the following SQL statement, but have no idea how to retrieve the distance in that same SQL statement, does anyone know?
DECLARE @latitude REALDECLARE @longitude REALDECLARE @postalCode CHAR( 4 )DECLARE @radius INT
SET @postalCode = '4037'SET
On 15/11/2006, at 11:27 AM, Taco Fleur wrote:
I am able to retrieve surrounding suburbs with the following SQL
statement, but have no idea how to retrieve the distance in that
same SQL statement, does anyone know?
Couldn't you do something like this:
SELECT suburb, postalCode,
If performance is an issue and you use pythagorus, then don't find the
square root of the two squared sides, but compare it to the squared
distance desired.
e.g. if you want to know things within a 10 km distance, then compare
X*X+Y*Y 100.
Finding a square root is extremely expensive
I've come into this thread late so ignore if the attached has been
posted already or unnecessary, but here is code that takes into account
the curvature of the earth.
cfset radian = 57.2958
cfset pi = 3.14159
cfset lat1rad = lat1 / radian
cfset long1rad = long1 / radian
cfset lat2rad = lat2
Taco how are you taking account of the fact that some places can have
two postcodes?
For instance, in NSW, St Leonards is postcode 2065 but PO Boxes in St
Leonards are postcode 1590
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
Wouldn't the lat and long be the same for both?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Wednesday, 15 November 2006 12:31 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: [OT] Calculate distance with long/lat
Hi Mike,
We've removed the post offices and po boxes, only have 32 thousand plus
suburbs.
Mike Kear wrote:
Taco how are you taking account of the fact that some places can have
two postcodes?
For instance, in NSW, St Leonards is postcode 2065 but PO Boxes in St
Leonards are postcode 1590
Hi Robin,
First of all, let me tell you that I am not smart enough to even begin
to understand how that calculation works, I've just copied it from
somewhere, figured out what makes it work and translated it to SQL.
Other than that I don't even know if it is the right way of doing it
(obivously
I'm using the following now, which I'm sure has it's pro's and cons, but it seems to work for now.
function BaseClass( name ){this.name = name;}BaseClass.prototype.getName = function() {return this.name;}
function SubClass( name ) {var base = new BaseClass( name );for ( func in base ) {this[
12 matches
Mail list logo