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 / senthil

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is mysql installed on linux?

965

What is the use of mysql_fetch_array () function in php?

995

Write a query to display current date and time?

973

What is limit in mysql?

913

How do you connect MySQL database with PHP?

1034

Difference between CHAR and VARCHAR?

1160

What is meant by mysqli?

952

Is mysql a distributed database?

1023

How to include comments in sql statements?

1015

What is database url for mysql?

1017

How many triggers are possible in mysql?

1007

How do I create a stored procedure in mysql?

937

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1436

How to do login in mysql with unix shell.

1157

How many threads can mysql handle?

1031