Hi All,

I am building a system where the users search results are cached.

This system uses SQL server and ASP.

Currently, I am storing the results in SQL Server. The record count for the table could easily exceed 1 million records with a content field storing the results as a text type field. Unfortunately, I have found the only way to display the result set of a text field is to cast it as a varchar(8000). This appears to be a limitation for the size of data I can store, unless I can accomplish it another way.

Question: Under these circumstances, is it going to be faster to retreive the data from the SQL server or use the Scripting.FileSystemObject in ASP to get the results file stored on the hard drive?

Thanks in advance....
Mike