I am having a SPList with some 500 records/items in it.
My visual web part used to read this SPList whenever the page loads and the SPList was populated by a timer job on a daily basis. The customer says that, after 6 months the data in the SPList increase dramatically.
How do I handle this kind of situation? If the number of items in a SPList is in the millions, how do I performance tune this SPList? If its document library, I can create folders and push the information into the folders and sub-folders but can we create folders in SPList? Or any other approaches are available for handling millions of items in a SPList?