Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

how fastest access of data can be done from database ?

Question Posted / alok raghuvanshi

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 are the advantages/disadvantages of mysql and php?

0 Answers  

What is mysql server used for?

0 Answers  

all the queries used in sql

0 Answers   TCS,

Why use stored procedures in mysql?

0 Answers  

How does mysql store binary data?

0 Answers  

In mysql, what is the default storage engine?

0 Answers  

What is delimiter in mysql?

0 Answers  

what is JOIN? Give example & types of join?

14 Answers   iMedia, Millennium, RAM Software, Satyam,

what is mysql optimization in brief?

0 Answers  

Can I use mysql for free?

0 Answers  

How do I find the database name in mysql?

0 Answers  

What does myisamchk do?

1 Answers  

For more MySQL Interview Questions Click Here
Categories