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
What is pdo in mysql?
What are the different types of triggers in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What is data type for image in mysql?
What is the difference between is null & is not null?
What is difference between group by and order by clause?
Can you rename a database in mysql?
What is latest version of mysql?
How do I setup mysql?
What do you mean by % and _ in the LIKE statement?
What is difference between mysql_connect and mysql_pconnect?
What are the differences between char and varchar data types?
What is difference between microsoft sql and mysql?
What is slow query log in mysql?
What is mysql_connect?