MySQL vs Web Server for data processing

Question

I was wondering if it is faster to process data in MySQL or in a server language such as PHP or Python. I am sure that native functions like ORDER will be faster in MySQL due to indexing, caching, etc., but actually calculate the rank (including links that return multiple records as having the same rank):

SQL example

SELECT TORCH_ID,
    distance AS thisscore,
    (SELECT COUNT(distinct(distance))+1 FROM torch_info WHERE distance > thisscore) AS rank
    FROM torch_info ORDER BY rank

Server

... as opposed to simple execution SELECT TORCH_ID FROM torch_info ORDER BY score DESC, and then determine the rank in PHP on the web server.

Answer 1

MySQL, , . , 90% , , ? -/ , , .

Answer 2

, " -", " ".

• -. . , .
• , , . SELECT *, -, , x = 3, SELECT * WHERE x = 3
• , , ..

Answer 3

, . , , mySQL, , PHP .

Answer 4

, . , , , , .

Answer 5

, . , torchID ...

, mySQL , .

, , , , - , SQL . . " " .

, , 10 000 , 1000 , , 100 , . , 100 , 10% (9999), 1000 .

.

Answer 6

, JDBC- ODBC dsn, 2-3 . ( , odbc dsn )