how fastest access of data can be done from database ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bharanikumar
use mysql_fetch_object instead of fetch_array ,
SET cache ,
SET GLOBAL query_cache_size=5000
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / alok raghuvanshi
please tell me the algorithms or the way how fast access and
retrieval can be done from database using mysql ?????
Thanx in advance.
Is This Answer Correct ? | 0 Yes | 3 No |
What is the maximum number of records in mysql table?
What is a session in mysql?
What is blob datatype in mysql?
How to get nth highest salary from table in a mysql?
How to get current MySQL version?
How do you insert a table?
How to store binary data in mysql?
What is mysql_pconnect?
Write a program using the select statement, while loop.
What are the different table present in MYsql?
What is the difference between primary key and candidate key?
In mysql, what is the default storage engine?