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

What is a mysql server?

505


How to use like conditions?

538


What are procedures in mysql?

483


Is blocked because of many connection errors unblock with mysqladmin flush hosts?

491


what is a cursor? : Mysql dba

477






What is an example of a delimiter?

484


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1733


How we can get distinct columns values in mysql?

593


How to insert html code into mysql database using php?

527


How do I stop a mysql command?

475


What is innodb_buffer_pool_size?

456


How do you kill a long running query in mysql?

458


What is mysql and why it is used?

550


How to display top 10 rows in mysql?

572


How do I kill a mysql connection?

463