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 MySQL?
What is longblob?
Is mysql relational?
What are aggregate functions in mysql?
What are the difference between and myisam and innodb?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is innodb_buffer_pool_size?
Is sql similar to mysql?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
How do you create a table in mysql workbench?
How do I automate a backup in mysql?
What is msql?
How can we run batch mode in mysql?
Explain the difference between primary key and candidate key in mysql?
What is the latest version of php and mysql?