Performance Suggestion

[DoughBoy]

I am in the process of re-writing a site that was in classic asp to asp.net. As part of the process I am looking to re-write some processes that are heavily hit and very important. The site uses a mix of different ways to handle large recordsets including SQL stored procedures, creating an xml document created by a vbscript file from sql and finally storing xml in application memory. So to make my long story shorter what I am trying to figure out is performance wise what is the best solution storing data in a table, an xml document or in application memory as xml. The data once calculated and put into one of these formats would be read only. Thoughts on direction and/or methods to come up with the best solution without trying each???


Thanks,

DoughBoy