Implementing distance matrix 2500 X 2500
Posted by:
Felix John
Date: December 13, 2004 11:06AM
Hi folks,
We would like to implement a distance matrix as a web database. (2500 rows X 2500 columns). Basically there are 2500 places and the table contains the distance between each and every place. Assume that this is a read-only(non-scalable) database. Can anybody suggest how the table structure should be for optimal performance over a dial up internet connection to a heavy traffic site ?
Queries would normally be to find all the places around 1km, 2km etc..
Help of any sort would be appreciated...
Cheers,
Felix & Alex.
Subject
Views
Written By
Posted
Implementing distance matrix 2500 X 2500
5664
December 13, 2004 11:06AM
3058
December 13, 2004 02:46PM
3096
December 14, 2004 12:08AM
2796
December 14, 2004 12:14AM
2669
December 14, 2004 12:22AM
2747
December 14, 2004 12:30AM
2774
December 14, 2004 02:11AM
2654
December 14, 2004 08:20AM
2803
December 14, 2004 02:53AM
2583
December 14, 2004 08:25AM
2711
December 14, 2004 08:43AM
2752
December 21, 2004 01:54PM
4273
December 15, 2004 01:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.