NYCPHP Meetup

[michael]

On Mon, 9 Jan 2006 16:03:16 +0330
Amir Aavani <amir.aavani at gmail.com> wrote:

> I developed a web-site which needs to retrieve some data from
> database on every request. These data are dynamic and retrieving them
> from database take a long time.

If retrieving the the data is what takes a long time then it sounds
like the database may need some tuning, not the app. Indexing is known
to help.  Perhaps a 'datamart' style table would help too.. for example,
summarize the data down to the elements the web is looking for.  This
can be done automagically with procedures/triggers on the underlying
base tables,  with a scheduler in the OS or the DB, or with whatever
routine that runs every 2 hours that updates the data.. The web app
could then call a faster/simpler select.


-- 

Michael