'How to speed up data retrieval time if there are 5 lakh records in a table?'.
'How to speed up data retrieval time if there are 5 lakh records in a table?'.
Too vague to answer. What database platform you are running on?
Are you retrieving everything or few records. Indexes, defragmentation, placement of data files have impact on speed of retrieval.