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

Why is mysql popular?

934

What can I do with mysql?

979

How does php communicate with mysql?

952

What are the differences between char and nchar?

1176

How do I optimize a selected query in mysql?

976

How do I use mysql?

931

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1060

How to use sum function in where clause in mysql?

1009

What is the difference between having and where clause in mysql? Explain

1072

What is the datatype of image in mysql?

969

What are numeric data types?

1039

How many sql dml commands are supported by 'mysql'?

1023

How is data stored in mysql?

973

What is the difference between truncate and delete in mysql?

1171

What are the different column comparison operators in mysql?

988