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 is mysql root?

0 Answers  

Can you tell how many values can set the function of mysql to consider?

0 Answers  

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 we can find nth max salary from an employe table by using my sql?

8 Answers  

How do you create a table in mysql workbench?

0 Answers  

What is mysqlcommand?

0 Answers  

How is oracle different from mysql?

0 Answers  

What is the purpose of mysql database?

0 Answers  

How to use like conditions?

0 Answers  

How to update info already in a table and delete a row(s) from a table.

0 Answers  

How do I find users in mysql?

0 Answers  

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  

For more MySQL Interview Questions Click Here
Categories