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...

how fastest access of data can be done from database ?

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

Is mysql written in c?

897


change column name and make a unique column so we get no dupes.

978


Does adding an index lock a table?

958


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4657


what is constraints? Also explain the different types of constraints?

963


What is difference between oracle and mysql?

916


How important is to list the column names when doing an insert?

1036


What are the difference between and myisam and innodb?

1019


Is mysql same as sql?

890


How do I start mysql from command line?

1002


How to write optimized query in mysql?

987


What is a csv table?

1001


Explain the difference between delete and truncate.

982


How to change the database engine in mysql?

988


What is innodb mysql?

1080