I have completed the logical design for a piece of work, and now am thinking about how I can implement it. Originally when analysing it I had thought that I would be writing the data to a database and using stored sql to do any updates, but my manager thinks that indexed files may be the way to go. I have never programmed to indexed files and do not see how to implement a database design as a series of indexed files. Does anyone know of a good resource on indexed files, or have any suggestions on how I may do it or things to watch out for. To give you some perspective there is going to be about 3/4 million accounts in the accounts table and about 9 million cli's where one account can have many cli's associated with it.
Thanks