mysql
MySQL
Building TreeView Navigation using JQuery
Tagged:
Using treeview we provide navigation facilitating visitors directly choose the link in website. We can provide a menuhierarchy, according to the group. visitors can directly select the
menu with single click. In this guide node data stored in mysql database. Using php we will fetch from mysql then mapped into treeview.
Dynamic DropDown List
This
tips will be useful when visitors faced with the Form contains relational dropdown list, for example, selection of categories - sub-category, Country-State/Province.
Upload image file to MySQL database
This tutorial describe step by step tutorial how to save image file (binary) into MySQL database. and how to retrieve the image back from MySQL database.
Enabling query cache to speed up mysql performance
Tagged:
Query cache can speed up fetching time for frequently used queries. At second same query (if result still same) MySQL know that the query will produce the same result, so MySQL fetch it from memory, not seeking trough the disk again. This will speed up fetching time.
Query cache feature has added to version 4.x.x as default. You can check this feature as follows :
