- Import the file daily once or twice from an FTP location into my database. (File size would be around 10MB to 15MB).
- display the data on the application screen
- Create a screen for search criteria for already uploaded records.
- Create three different reports according to the fields in the records
Uploading and searching of the data must be fast as the number of records would be very high, approx: 5Lakhs daily.