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

How to load data from a text file into a table?

7 Answers   Sasaa,


What is maximum size of a database in MySQL?

13 Answers   Wipro, V2 Solutions, CIS, Bastioncoup, NM,


what is the difference between MyIsam and InnoDb engine?

2 Answers  


How do you index just the first four bytes of the column?

2 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: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  






What is Database?

2 Answers  


Explain the architecture models of SQL Server?

0 Answers  


Explain the difference between BOOL, TINYINT and BIT?

1 Answers  


What is ACID?

2 Answers  


How do you start MySQL on Linux?

3 Answers  


what is collation? how many types of installations in sql server?

3 Answers  


How to find out the second largest element from mysql table

15 Answers  






Categories