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
Is mysql written in c?
change column name and make a unique column so we get no dupes.
Does adding an index lock a table?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
what is constraints? Also explain the different types of constraints?
What is difference between oracle and mysql?
How important is to list the column names when doing an insert?
What are the difference between and myisam and innodb?
Is mysql same as sql?
How do I start mysql from command line?
How to write optimized query in mysql?
What is a csv table?
Explain the difference between delete and truncate.
How to change the database engine in mysql?
What is innodb mysql?