• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Pawn] How does one make a top5?
#7
Going through "user files"? Is unnecessary? Is an issue somehow? Do you know how MySQL works?



You found the secret text!

If your database (and server, and system, eventually) is set up properly there's no issue at all.

An old InnoDB users table from some server backup, 11.140 rows, 7.2MiB. 97 columns (this database wasn't set up properly). Using the query from above, it takes about 0.0155-0.020 seconds. Selecting all data (*) would take about 0.065-0.07 seconds.

It's on so many levels different than "going through user files" (as in ini-based includes).



Also keep in mind: MySQL is a relational database management system. It's designed (atleast one of the reasons) to be able to perform eventually complex queries to find data in seperate tables,eventually databases. Such a simple query as above is nothing
  Reply


Messages In This Thread
How does one make a top5? - by Z3fRaN - 2021-02-26, 01:37 AM
RE: How does one make a top5? - by Virsenas - 2021-02-26, 02:18 AM
RE: How does one make a top5? - by Z3fRaN - 2021-02-26, 02:22 AM
RE: How does one make a top5? - by Virsenas - 2021-02-26, 04:24 AM
RE: How does one make a top5? - by Kwarde - 2021-02-26, 05:22 AM
RE: How does one make a top5? - by Virsenas - 2021-02-26, 11:54 AM
RE: How does one make a top5? - by Kwarde - 2021-02-27, 02:26 PM
RE: How does one make a top5? - by Virsenas - 2021-02-27, 08:43 PM
RE: How does one make a top5? - by arber - 2021-02-27, 11:30 PM
RE: How does one make a top5? - by Radical - 2021-02-27, 11:45 PM
RE: How does one make a top5? - by Z3fRaN - 2021-02-27, 11:55 PM

Forum Jump: