use mysql_fetch_object instead of fetch_array , SET cache , SET GLOBA

how fastest access of data can be done from database ?

Question Posted / bharanikumar

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

Please Help Members By Posting Answers For Below Questions

Does uninstalling mysql delete database?

1012

How do I view a mysql database?

898

What is orm in mysql?

902

What is the difference between procedure and function in mysql?

1016

How to rename an existing column in a table?

1048

What is myisamchk?

948

How to write after insert event update trigger on the same table in mysql?

953

What is the data type for file in mysql?

981

What is the default password for mysql?

893

Write a program using the select statement, while loop.

899

How to calculate the difference between two dates?

1056

How do you flush privileges?

967

How to delete a table.

920

what is cte? : Mysql dba

941

What is trigger in mysql?

924