how fastest access of data can be done from database ?
- 3 Answers
- 4625 Views
- I also Faced
- E-Mail Answers
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 a join? Explain the different types of mysql joins.
How do we use % when performing a search query?
What is difference between group by and order by clause?
can you tell how can you display the maximum salary in sql? : Mysql dba
What is the difference between primary key and candidate key?
How do I start mysql from command line?
How do I run mysql from command line?
How to rename an existing table in mysql?
What is mysql_query?
How many entries can mysql handle?
How do I create a stored procedure in mysql?
What is check constraint?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
