2021-02-27, 10:15 PM
Hi, I recently had 2 questions that I wanted to discuss here on the forum.
First Doubt: The efficiency of a script
when we develop systems, we realize that there are several different ways to write the system and get the expected result, however there are more efficient ways that cause less impact to the server.
I would like to know, what would be the best way to qualify the efficiency of a script. Would the script execution time be a valid parameter for this type of test?
Second Doubt:?When to use or not to use the data directly from the bank
In this second question I would like to know the best way to work with MySQL. For example, in a system that makes queries, additions and updates the best and most efficient way would be to load this sql data into variables, manipulate those variables and then update the data sql, or do all the manipulations directly in the database?
First Doubt: The efficiency of a script
when we develop systems, we realize that there are several different ways to write the system and get the expected result, however there are more efficient ways that cause less impact to the server.
I would like to know, what would be the best way to qualify the efficiency of a script. Would the script execution time be a valid parameter for this type of test?
Second Doubt:?When to use or not to use the data directly from the bank
In this second question I would like to know the best way to work with MySQL. For example, in a system that makes queries, additions and updates the best and most efficient way would be to load this sql data into variables, manipulate those variables and then update the data sql, or do all the manipulations directly in the database?