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.

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

0 Answers  

---

Write a query to select all teams that won either 1, 3, 5 or 7 games.

0 Answers  

---

How do you index just the first four bytes of the column?

2 Answers  

---

Explain the difference between mysql and mysqli interfaces in PHP?

10 Answers   TCS,

---

How to delete a table.

0 Answers  

---

Write a program using the select statement, while loop.

0 Answers  

---

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

Do I need to pay for mysql?

0 Answers  

---

Is mysql port 3306 tcp or udp?

0 Answers  

---

Where is the mysql config file?

0 Answers  

---

How internally data stores in MyISAM and INNODB table types?

0 Answers   Zensar,

---

What is latest version of mysql?

0 Answers  

---