MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 3 1999 5:48pm
Subject:Re: mysql vs. text file
View as plain text  
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.


mysql and excelStuart D Jackson3 Aug
  • Re: mysql and excelSteve Ruby3 Aug
  • RE: mysql and excelMichael Robinson3 Aug
    • mysql and excelFRed3 Aug
    • RE: mysql vs. text fileEe Loon3 Aug
      • Re: mysql vs. text fileChristian Mack3 Aug
      • RE: mysql vs. text fileKelly Yancey4 Aug
        • Re: mysql vs. text fileMartin Ramsch4 Aug
          • Re: mysql vs. text fileSteve Edberg4 Aug
            • PHP as CGI script (was: mysql vs. text file)Martin Ramsch4 Aug
              • RE: PHP as CGI script (was: mysql vs. text file)Kelly Yancey4 Aug
                • Locking problem?Arlen Greer4 Aug
                  • Re: Locking problem?Patrick Sherrill4 Aug
                    • RE: Locking problem?Arlen Greer5 Aug
                      • Re: Locking problem?Christian Mack5 Aug
RE: mysql and excelWilliam D. Webber3 Aug
Re: mysql and excelRalph Graulich4 Aug
RE: Locking problem?Quentin Bennett5 Aug