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

What storage engines are used in MySQL?

984

How we can create index in mysql?

923

What is the difference between truncate and delete in mysql?

1083

Can I copy mysql data directory?

873

Is sql and mysql same?

873

Is mysql running ubuntu?

916

What is a session in mysql?

915

What is 'mysqldump'?

988

How do I view data in mysql workbench?

955

Explain triggers and stored procedures?

872

How do I install and use mysql?

888

How do I change directories in mysql?

870

How do I copy an entire mysql database?

832

What is mysqli_connect_error ()?

971

Which datatype is used for email in mysql?

911