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 maximum size of a database in MySQL?

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

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

8 Answers  

What is SERIAL data type in MySQL?

3 Answers   Aspire,

What is A BI Ap;plication?

1 Answers   HCL,

How can we know the number of days between two given dates using MySQL?

2 Answers   Webworks, Base2 Infotech,

How to get full name of monthname ?

4 Answers  

How can we repair a MySQL table?

2 Answers   Infosys,

Hi! I’m doing one Project in 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

maximum database size of mysql database

2 Answers  

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

How internally data stores in MyISAM and INNODB table types?

0 Answers   Zensar,

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers