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 we can create index in mysql?

482


How to shutdown mysql server?

558


Does insert statement lock the table?

486


What is the use of mysqli_connect in php?

451


What is mysqladmin flush hosts?

476






How do stored procedures work?

465


How do I download mysql on my laptop?

466


Is number a datatype in mysql?

466


Restore database (or database table) from backup.

539


What is the use of mysqli_fetch_assoc?

473


Can we store videos in mysql database?

473


What is a join in mysql?

468


How do I add a column to a table in mysql?

457


How do I copy a table in mysql?

463


How to display odd rows in student table in mysql?

447