From: Piyush Ranjan <piyush.pr@...>
Date: 2007-11-26T11:55:59+09:00
Subject: Re: ruby cache

------=_Part_34876_30634198.1196045762003
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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?
>
>

------=_Part_34876_30634198.1196045762003--