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
How to add a new column to an existing table in mysql?
What is the full form of mysql?
Where’s database data actually stored?
How can you retrieve a particular number of records from a table?
Can we store files in mysql?
How do I show all mysql databases?
What is difference between microsoft sql and mysql?
What is identity in mysql?
Is oracle mysql free?
What is csv?
What is msql?
write a query to mysql in safe mode and to change the root password
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How to copy data from one server to another using php?
How do I rename a table in mysql?