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

Is mysql written in c?

837

How do I get a list of table names in mysql?

873

What is procedural api?

926

How to calculate expressions with sql statements?

1019

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

891

Can you tell how to find the number of rows in a resultset using php?

859

What is full text indexing in mysql?

897

How do I edit a database in mysql workbench?

858

How do you know the version of your mysql server?

1089

What are stored procedures and functions?

855

How do I install mysql on windows 10 64 bit?

870

Is pdo more secure than mysqli?

815

What is relational database in mysql?

874

What is mysql enterprise edition?

846

How to find second highest salary from a table?

958