Interested to Buy Any Domain ? << Click Here >> for more details...
how fastest access of data can be done from database ?
- 3 Answers
- 5223 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 |
How do you concatenate strings in mysql?
How can you change the password of a mysql user?
Create table employee (eno int(2),ename varchar(10)) ?
What is datadir?
What is the difference between truncate and delete?
If we use sum function in mysql, does it return sum of that row or for that column?
How do I show columns in mysql?
Give the syntax of REVOKE commands?
What is mysql enterprise edition?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
What are features of mysql?
What is the datatype for password in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
