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 are the advantages/disadvantages of mysql and php?
What is mysql server used for?
all the queries used in sql
Why use stored procedures in mysql?
How does mysql store binary data?
In mysql, what is the default storage engine?
What is delimiter in mysql?
what is JOIN? Give example & types of join?
14 Answers iMedia, Millennium, RAM Software, Satyam,
what is mysql optimization in brief?
Can I use mysql for free?
How do I find the database name in mysql?
What does myisamchk do?
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)