Hi,
Me and Ricardo are newbies at progress/webspeed. We are last year students and are busy with our Training period.
We need to create a search engine web application for Questions and Answers, but our search query is not optimal, it takes no more than a couple seconds to process the search without sorting, but it takes more than 5 minutes (CGI error) to process 5000 records if we sort it by relevance.
Every time the query finds a match, we update this record with some temp fields (number of matching words, etc) so we can sort it by relevance. Maybe this is te problem?
Maybe someone can help us.
thanks in advance.
Me and Ricardo are newbies at progress/webspeed. We are last year students and are busy with our Training period.
We need to create a search engine web application for Questions and Answers, but our search query is not optimal, it takes no more than a couple seconds to process the search without sorting, but it takes more than 5 minutes (CGI error) to process 5000 records if we sort it by relevance.
Every time the query finds a match, we update this record with some temp fields (number of matching words, etc) so we can sort it by relevance. Maybe this is te problem?
Maybe someone can help us.
thanks in advance.