| Author |
 Topic  |
|
|
guinsu
Starting Member
9 Posts |
 Posted - 07 May 2002 : 11:08:30
|
Search the forums at my site (forums.dealcatcher.com) is really slow when looking for terms with a lot of results like 'amazon'. I've been going through the code and trying to make changes to speed it up but I haven't had much luck. I've tried fixing some flaws in the code that actually retrieves search results, but apparently that isn't the slow part.
I've found that for every row in the table there are a number of DB lookups that seem to be slowing things down. The following are attempts I made to speed things up.
First, the SQL query around line 110 in search.asp returns duplicate records (I guess if the search term was found in a topic or in any replies). That was fixed by changing the start of the query to:
strSql = "SELECT DISTINCT " & strActivePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_SUBJECT....
I haven't found any bad side effects from doing this.
I also rolled the SQL query from line 225 into this other query. The changes are a bit long to include here, but I can clean them up and post them if anyone is interested.
These changes dropped the search time from about >30 to around 20 seconds, but that still isn't good enough. The actual search itself is really quick, does anyone have any suggestions how I can speed up all the other checking that goes into displaying the results?
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 May 2002 : 11:50:29
|
look in the de discussions forum, there are some discussions on speeding up active.asp and such, the discussions would still apply to the search pages.
However, as a quick off the top of my head hint.
Most of the delays are cased by checking things like subscriptions/moderation and whether you actually have access to the post etc.
It maybe better to ascertain for instance which forums the user has access to prior to doing the query, and add an extra parameter to the query so it only returns posts for forums which you have access, this will save it cecking after wards, and maybe the same for moderated posts etc, adding them as parameters to the queery will save the asp having to do the iterations which is the slow bit.
|
 |
|
| |
Topic |
|
|
|
Topic Locked
