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

i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??

1 Answers   WebTech,


Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  


How do you convert to a different table type?

1 Answers  


why not null is not allowed at table level

0 Answers   Cognizant,


I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  






what is the querry for all managers salary?

2 Answers  


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

0 Answers  


Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 Answers  


Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

1 Answers  


SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,


What does tee command do in MySQL?

1 Answers  


Explain federated tables?

3 Answers   Tech Mahindra,






Categories