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|
i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??
Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters
How do you convert to a different table type?
why not null is not allowed at table level
I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?
what is the querry for all managers salary?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
SELECT country,city FROM customers GROUP BY country ORDER BY city DESC
What does tee command do in MySQL?
Explain federated tables?