Web Development Tips & Tricks

In this article, I will talk about the speed of the JOIN table in various forms of MySQL , which will be useful. In choosing the right command style in order to get the fastest results The test is nothing much. I tested the functionality on phpMyAdmin and then saw the results of the query speed from phpMyAdmin . If applied to other tests, try it. Testing, I chose the test command in the JOIN group to select all the data to be displayed. It is a query that gives the same result in 3 types without sorting. SELECT I.*,T.* FROM eduparty_index AS I INNER JOIN eduparty_template AS T ORDER BY I.username 3,060 total, keywords lasted 0.1406 seconds SELECT I.*,T.* FROM eduparty_index AS I CROSS JOIN eduparty_template AS T ORDER BY I.username 3,060 total, keywords lasted 0.1145 seconds SELECT I.*,T.* FROM eduparty_index AS I,eduparty_template AS T ORDER BY I.username 3,060 total, keywords lasted 0.1043 seconds The total time obtained is the average time for each order...

Prioritization within the WHERE clause of MySQL has a profound effect on query performance, especially in the case of the database is large or complex queries, in which MySQL processes the SQL statements from left to right. The important principle of the priority of queries in this section is to specify the results that are ordered in ascending order from left query to right query. I give an example of the member database. Suppose there are 100 records in total. 50 men, 50 women and have a unique name. I want information that is male. SELECT * FROM user WHERE sex='m' I will get 50 records. If I need information called test. SELECT * FROM user WHERE username='test' I will get only one record (if any). The above command will execute a loop from the first record one by one and compare the data within the WHERE statement. Of course, it will need to process 100 cycles according to the amount of data. Suppose, if I want the data named test male, I ca...

Many people may not know how MySQL has the sequence of the SELECT statement that we use. And many others as well, probably asking me, why do we know it (FA) In the official program Determining the order of work, It is very important. Determining the correct order will result in the result being incorrect. It may cause the result to be incorrect, such as multiplying 2 + 5 * 3 multiplying before adding. Will get the result 17, but if adding before multiplying Will get a result of 21 which is not equal As for the result, it will be correct depending on the problem. Which we have a way to force the result to be always correct with the work order such as SELECT 2 + 5 * 3 และ SELECT 5 * 3 + 2 The result will always be 17 since MySql will always execute * before +. Therefore, if the correct result is 21, then this calculation will be wrong. Control results are always accurate by placing parentheses around the order in which MySQL will calculate the results from Innermost brac...

MySQL is at the heart of another Web Server. Because MySQL is a source of information that can be used quickly. Today I will take the experience of Config MySQL to read. Beginning with PHP Compile to support MySQL. Usually, Compile PHP supports MySQL with --with-mysql. This method will use the MySQL Lib Client Bundle with PHP, which is the old version. There is also a new extension called MySQLi. If using MySQLi will not You can use the MySQL Lib Client that Bungle comes with. It will be a hit, so to start, I'd recommend Compile PHP as well --with-mysql = / usr / local / mysql (or if mysql is somewhere else, use a different path). For ease of use, Thai language is usually setup in my.cnf that default-character-set = tis620. This method will cause MySQL to run around 20 - 30% slower, but that's fine. Because anyway I have to use Thai already After putting the statement that default-character-set = tis620 into my.cnf, then I get the MySQL Client. It's a must ...