Hi
I have a large print file which contains records for about 5000 individuals, each record is about 50 lines of text. In my web app I want each person that has a record in the file to be able to retrieve it. I store the record location (currently the line no. within the file) together with their ID number in an SQL Server Database.
My question is what is the quickest way to arrive at the location and retrieve the record, should I read the file line by line or should I use SeekOrigin and Offeset to arrive directley at the location.?
Please include a short coding sample of the best method to use.
Thanks
I have a large print file which contains records for about 5000 individuals, each record is about 50 lines of text. In my web app I want each person that has a record in the file to be able to retrieve it. I store the record location (currently the line no. within the file) together with their ID number in an SQL Server Database.
My question is what is the quickest way to arrive at the location and retrieve the record, should I read the file line by line or should I use SeekOrigin and Offeset to arrive directley at the location.?
Please include a short coding sample of the best method to use.
Thanks