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

What is pdo in mysql?

871


What are the different types of triggers in mysql?

912


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

971


What is data type for image in mysql?

824


What is the difference between is null & is not null?

938


What is difference between group by and order by clause?

908


Can you rename a database in mysql?

948


What is latest version of mysql?

942


How do I setup mysql?

852


What do you mean by % and _ in the LIKE statement?

944


What is difference between mysql_connect and mysql_pconnect?

971


What are the differences between char and varchar data types?

1009


What is difference between microsoft sql and mysql?

923


What is slow query log in mysql?

1028


What is mysql_connect?

900