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 MySQL?

1000


What is longblob?

982


Is mysql relational?

913


What are aggregate functions in mysql?

1369


What are the difference between and myisam and innodb?

1022


what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1091


What is innodb_buffer_pool_size?

980


Is sql similar to mysql?

890


i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2596


How do you create a table in mysql workbench?

929


How do I automate a backup in mysql?

992


What is msql?

994


How can we run batch mode in mysql?

1059


Explain the difference between primary key and candidate key in mysql?

965


What is the latest version of php and mysql?

1214