Tag Archives: SQL
MySQL Query – No Quote For String Fields
One of the module in our project, it is experiencing a slow performance. The module will let the user scan the PCB barcode of an item and updated a record on the database. It was originally built on MyISAM table … Continue reading
Posted in Database
Tagged index not hit, mysql, mysql index, mysql query, no quote, SQL, sql index
Leave a comment
From SQL Script to Zend Db Query
Yesterday, I have debugged an AJAX request that gets a value from the database. It was actually me who developed that module and all calculations and SQL query are based on the specifications given by our analyst. The query was … Continue reading
