how fastest access of data can be done from database ?

Answer Posted / bharanikumar

use mysql_fetch_object instead of fetch_array ,

SET cache ,

SET GLOBAL query_cache_size=5000

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I setup a mysql database?

678


Why mysql is so popular?

699


Is mysql deprecated?

648


What is difference between mysql mysqli and pdo?

638


What is difference between mysql_connect and mysql_pconnect?

731


What can you do with mysql?

680


Is mysql open source?

655


What is a string in mysql?

659


How to use in conditions?

732


How do I rename a mysql database?

694


What is mysql primary key?

694


Who owns mysql database?

780


How do I quit mysql?

665


What are the non-standard sql commands supported by 'mysql'?

701


How to include numeric values in sql statements?

706