Information générale
Titre:
Performance Question
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement