Hi everybody! I am querying from a table containing more than 40,000 records. Earlier when the records were 10,000 it was taking 9 sec and now after 1 year and 40,000 records its taking 30 sec. Code is the same.
I am pretty sure that it has something to do with database only. No body can think of spending 30 secs for retrieving values from tables unless it's very huge in the sense of millions of records. I don know whether I have to modify my database or do some sort of restructuring or reindexing so as to make it fast enough. Is there some methods or optmization which can be applied to this database which hasn't been touched since design to enhance the spped. If there are some quick ones but valued alottttttt please let me know. Thanks in advance Binay
