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 to list or view all databases from the mysql server.

546


How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

485


Why is the basic difference between left join, right join and inner join?

560


What is row locking in mysql?

515


How many rows can mysql handle?

514






How to shut down the server with 'mysqladmin'?

556


How to get a list of indexes of an existing table?

535


Can you rename a database in mysql?

536


How to see the create table statement of an existing table?

586


What is mysqli_connect_error ()?

533


What is the use of procedure in mysql?

486


What is a mysql server?

529


How do you know if your mysql server is alive?

510


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

531


What is a left join mysql?

487