hi all, i was tasked to develop a records sytem that will store on a database probably sql server 2005. the main function of the program is to store records and be able to retrieve them to for report generation, and it should be efficient and fast when a query is thrown to the program.
basic scenario: a client or say a graduate of the school will ask for a form and what the record personnel will do is to enter the client's name and the record will appear, the record's personnel then will be able to print a report or form.
- what techniques should i use when designing the database so when there is a search query, the program wont take a long time to produce output, this question seems to be out of the topic but im desperate. thanks.
- will sqlserver be a good choice?
- is it ok to use prebuild database navigation control to add, update and delete record?
ps: the records may range from hundreds of thousands to millions.
thanks in advance and i hope anyone can enlighten me with this since im only given a month to plan and code this project.