how fastest access of data can be done from database ?

Answers were Sorted based on User's Feedback

how fastest access of data can be done from database ?..

Answer / senthil

We can retrieve data fast
1. By the query optimization
2. Set the index for Not null fields(varchar data type)
3. BY using the join query

By using the mysql_fetch_array() function to retrieve the data

Is This Answer Correct ?    0 Yes 0 No

how fastest access of data can be done from database ?..

Answer / 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

how fastest access of data can be done from database ?..

Answer / alok raghuvanshi

please tell me the algorithms or the way how fast access and
retrieval can be done from database using mysql ?????
Thanx in advance.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More MySQL Interview Questions

what is the difference between MyIsam and InnoDb engine?

2 Answers  

Print 3 highest salary

9 Answers  

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

0 Answers  

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: Thanks, Kartik T

0 Answers  

What are the other commands to know the structure of table using MySQL commands except explain command?

2 Answers   SigmaTree,

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 usa 4 germany 5 usa 6 sureshbabu canada 7 pakistan 8. austria 9. sourthafrica 10. russia 11. sureshbabu australia 12. sureshbabu nepal 13. italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers   GE, Afixi,

what is the advantage of stored procedures, triggers and indexing in mysql

1 Answers  

how we connect the data base in any programme

2 Answers  

Explain the difference between mysql and mysqli interfaces in PHP?

10 Answers   TCS,

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  

Explain advantages of MyISAM over InnoDB?

1 Answers  

how we can find nth max salary from an employe table by using my sql?

8 Answers