Tag: sql

  • Techniques to Optimize MySQL: Indexes, Slow Queries, Configuration

    —

    by

    Mario
    in

    Many web developers see MySQL as the world’s most popular relational database. However, at some points, you will find many parts haven’t been optimized. However, instead of investigating it further, many people prefer to leave it at default values. As a solution, we have to combine the previous tips with new method that came out…

  • MySQL 5.7 Reference Manual

    —

    by

    Mario
    in

    Nowadays, MySQL is the most popular database system used with PHP among so many developers. PHP combined with MySQL are cross-platform which you can develop in Windows and serve on a Unix platform. Basically, tables stores the data in a MySQL database. A table consists columns and rows which is a collection of related data.…

  • PHP Prepared Statements

    —

    by

    Mario
    in

    Somehow for web developers, doing a query can be more complicated if it should face a large amount of data since you may have to repeat the same query for several times. Therefore, if you would like to input a large amount of database into your query, you can try using prepared statements to optimize…