| Author |
 Topic  |
|
sy
Average Member
United Kingdom
638 Posts |
 Posted - 16 August 2002 : 17:54:48
|
Easy way to improve performance would be maybe to return top 10 queries to static pages.
You could do this if we could find out the top 10 searches and forward them to pre-prepared results.
Doing this would help me achieve more anyway, i'll try it on my test forum, thanks for getting me thinking! |
The pessimist complains about the wind; the optimist expects it to change; the realist adjusts the sails
|
 |
|
|
Deleted
deleted
4116 Posts |
Posted - 16 August 2002 : 18:02:28
|
quote:
Originally posted by HuwR
not sure it would help, and it would certainly irritate me if I could no longer search for
a e i o u 
This is actually what I'm using to find my posts, filling the user field, setting "any" (this is because the "search" field is a required one) as discussed here ...
|
 Stop the WAR! |
|
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
Posted - 16 August 2002 : 19:00:54
|
quote:
Originally posted by bozden
quote:
Originally posted by HuwR
not sure it would help, and it would certainly irritate me if I could no longer search for
a e i o u
This is actually what I'm using to find my posts, filling the user field, setting "any" (this is because the "search" field is a required one) as discussed here ...
I really feel you need to think hard on the questions:how do I now?
"I need to reply to a topic"
"Did someone quoted me"
"I replied to a topic, but has someone posted something new"
Now it's all done using "subscriptions" or strange looking "search query's".
And with not that much experience here  I may have a solution too:
1.
In the "New Topic Page" add a "To:" field.
- The user can type in a member name (after submit translated to MemberID and saved in Topic table)
2.
In the "Topic Page".
- When you "reply with quote" to a message posted by MemberId 8, this MemberId 8 is saved in the Reply table)
Now my SQL knowledge is "none", and I don't know what used in 3.4 now.
But testing, with these new fields, in an access database gave answers to the above questions.
Shoot me
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 August 2002 : 20:47:46
|
1) it is a forum not an email program, so you are not replying directly to a member you are replying to A TOPIC
2) No it isn't
3) a forum is supposed to be an interactive experience, ie you come here and read the posts, if you want something else try a news group |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 August 2002 : 20:49:28
|
quote:
Originally posted by bozden
This is actually what I'm using to find my posts, filling the user field, setting "any" (this is because the "search" field is a required one) as discussed here ...
Me too, which is why it better not change
Plus, I have yet to see the search page bog down the server,
regardless of what you search for, if it is too much it will time out. |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 16 August 2002 : 22:28:42
|
| So, let me write a small "MPWH" mod... |
Stop the WAR! |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 17 August 2002 : 01:08:17
|
quote:
this is all that is being checked for:
fString = Replace(fString, "'", "''")
fString = replace(fString, ">", ">")
fString = replace(fString, "<", "<")
There are other filters currently in place such as the member.asp fix or even the badwords filter. How about sharing those filters or using similar filters?
quote:
As long as you ignore words like the, why, etc.
3 should probably be a sufficient minimum in most cases. Also, if the search can include spaces, these 3 letter words can be 4 or 5 letter words if theres a space before and/or after.
|
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 17 August 2002 : 04:55:18
|
quote:
Originally posted by bozden
quote:
Originally posted by HuwR
not sure it would help, and it would certainly irritate me if I could no longer search for
a e i o u
This is actually what I'm using to find my posts, filling the user field, setting "any" (this is because the "search" field is a required one) as discussed here ...
Why don't you use the link in your profile to find all your posts? |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 17 August 2002 : 06:48:12
|
| Last ten? What I was searching for is "did I miss any post in the last week/month?", and the result shows (say) some fifty rows. If the last poster is myself, nobody answered after my last post. I used to say the last word . |
Stop the WAR! |
|
|
|
Topic |
|
Topic Locked
