Searching slow

folks, how can i speed up SQL queries? Or rather the stored procedures? It takes so long to run some searches that the server gives up and times out. Is fine with subjects, its just the Message Body searches i cant do in all forums.

Using MS SQL
100k posts
2500 topics
28 forums

Indexes are all set up. Anyone know any way to make them faster???

tried it on oneandone and tried it on my own test server at home. Same on both.

???

I planning on completly re-writting some of the pages that are slow for version 8 in the next couple of days, particully the search and the default.asp page.

So hopefully in the next version there won't be any of these problems.

I've just finshed integrating version 3 of the RTE into the forum, which has taken me the best part of 11 hours, which I am currently testing on this site.

If anyone notices any problems with posting in the editor please le me know.

-boRg- he is on v6.34

V3 RTE is cool.. looked weird when i first looked at it and thought is that changed .. how hard was it to intergrate. i know 11 hours but code wise.. etc..

i think he is trying to get to V7.9.

are you planning on making access upgrade scripts again? i wont need it but i can already hear them calling ..lol

bruce i may have a mod you may want to add.

you may have heard of it... it is a where are my users MOD .. it tells you where everyone is .. it adds 2 fields to an array, and then can tell by the url (thats taken ) .. where you are. the only 2 places it uses queries is if you are within a forum or in a thread.

it can tell if your registering etc. and also dooesn't update if on the RTE pages. and others. i have made it so it by passes any queries if its you that is the row in the array.

also tells you how m,any are within the forum, using the 2 field in the array. and also allows for annominous viewing. but counts you..

if you want to see if you can see it at

http://www.fgcboard.ath.cx/active_users.asp
and
http:/www.support.emagine-hosts.com

if you want the latest version to look over.. i have it zipped on the desktop.. might be worth adding .., even if you want to allow a on off switch.

emagine site isn't very popular t present..

keep up the good work .. oo and have a rest also..

sorry for the long post.