Suggestion and Policy

Re:Software Suggestion
Staff 16924 reads
posted

Actually, we have addressed this issue in the past.  Good idea, just need to implement it.  One of the big problems is the performance of the search.  TER gets between 100-300 search requests per second.  Currently those searches are for numeric values in a 25000+ record provider table.  To do this, we would have to do a SQL “like” query on a the review table (where the text is stored) which has over 200,000 reviews to search. This would be a huge performance issue for the site.

I am not sure if the performance problems this would cause would outweighs the benefit.  Sorry for getting techie on you guys :-)

-- Staff

Im surprised that you dont have this feature already! I think we definteely need a KEYWORDS feature for searching reviews. For example, I like ukranian girls! If you have a keywords field, I should just enter Ukraine and it shold search the Juicy and General text box fields of all reviews and display reviews that contain that keyword. I think this suggestion should really help a lot of us!

Staff16925 reads

Actually, we have addressed this issue in the past.  Good idea, just need to implement it.  One of the big problems is the performance of the search.  TER gets between 100-300 search requests per second.  Currently those searches are for numeric values in a 25000+ record provider table.  To do this, we would have to do a SQL “like” query on a the review table (where the text is stored) which has over 200,000 reviews to search. This would be a huge performance issue for the site.

I am not sure if the performance problems this would cause would outweighs the benefit.  Sorry for getting techie on you guys :-)

-- Staff

Register Now!