Piyush Ranjan
11/26/2007 2:56:00 AM
Note: parts of this message were removed by the gateway to make it a legal Usenet post.
you can cache the geocode locations in the database itself and calculate the
distances on the fly. That should speed up things considerably. As soon as
you add/update a new/old author call geocoding function to populate lat,
long fields in the
db.
On Nov 26, 2007 6:55 AM, <ISAA.Berkeley@gmail.com> wrote:
> I am trying to improve the performance of a very simple web
> application. The web application let's you choose a library from a
> drop down box. then it goes to the database and loads the name and
> birth places of all entries in the authors table.
> then it gecodes the birthplaces of all the authors, computes their
> relative distance to the library and show the top 10. any ideas on how
> to do caching to speed things up?
>
>