Re: mysql vs. text file

[Christian Mack]

Ee Loon wrote:
> 
> hi:
> 
>  i have a efficiency question. i have a web applicaion
>  that will display the best 10 scores from a table.
> 
>   Each time a user enter to this site, i will produce
>  the best 10 scores. would it be more effiecient to
>  query the DB once everyday and store the 10 best
>  results in a file so that the web application can
>  access this file OR would it be more efficient for
>  the web application to query the DB each time a user
>  enter the site?
> 
> ----------------------------------------------
> Ee Liaw

Hi Ee Loon or Liaw?

It is more efficient to store the score result in a file and generate it once in a while.
This is, because there is no processing overhead with each hit.

But if this is the best solution depends on how "live" this score board has to be.

Tschau
Christian