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

Answer / bharanikumar

use mysql_fetch_object instead of fetch_array ,

SET cache ,

SET GLOBAL query_cache_size=5000

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.

How to show table names with 'mysqlshow'?

0 Answers  

---

What is mysql optimization?

0 Answers  

---

How to drop an existing view in mysql?

0 Answers  

---

How do I view a mysql database?

0 Answers  

---

What is mysqli_select_db?

0 Answers  

---

What is the use of mysqli_fetch_array?

0 Answers  

---

Is postgresql better than mysql?

0 Answers  

---

What does innodb stand for?

0 Answers  

---

How do I truncate all tables in mysql?

0 Answers  

---

Is mysql a distributed database?

0 Answers  

---

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  

---

Write a command to list all databases in mysql?

0 Answers  

---