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

How to add a new column to an existing table in mysql?

755


What is the full form of mysql?

746


Where’s database data actually stored?

733


How can you retrieve a particular number of records from a table?

693


Can we store files in mysql?

677


How do I show all mysql databases?

710


What is difference between microsoft sql and mysql?

682


What is identity in mysql?

732


Is oracle mysql free?

664


What is csv?

718


What is msql?

736


write a query to mysql in safe mode and to change the root password

743


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

692


How to copy data from one server to another using php?

757


How do I rename a table in mysql?

736