I agree. This had been posted on this forum at least a half a dozen times. Unfortunately, the answer is still the same.
Our current queries to the database average between 10-30 miliseconds. (this is the time that it takes for our SQL servers to respond to the ASP page once it requests information from the database) We currently get up to 200 queries per second against the database.
We did a performace test using a 'LIKE' SQL query against the review database. To parse the over 2 gigabyes of data in the review table searching for a keyword took on the average of 64 seconds. In another words, if we enabled this feature, it would slow the entire site down to a crawl.
-- Staff
Can we have a feature that lets you search for certain keywords in the actual reviews? This would be a very useful feature.
I agree. This had been posted on this forum at least a half a dozen times. Unfortunately, the answer is still the same.
Our current queries to the database average between 10-30 miliseconds. (this is the time that it takes for our SQL servers to respond to the ASP page once it requests information from the database) We currently get up to 200 queries per second against the database.
We did a performace test using a 'LIKE' SQL query against the review database. To parse the over 2 gigabyes of data in the review table searching for a keyword took on the average of 64 seconds. In another words, if we enabled this feature, it would slow the entire site down to a crawl.
-- Staff
Maybe you could add that option to an advanced search page. I know I'd use the hell out of it, and 1 minute isn't too long to wait for detailed query.