FUDforum: FUDforum Suggestions » Search logic failure &other stuff

Home » FUDforum » FUDforum Suggestions » Search logic failure &other stuff

Show: Today's Messages :: Polls :: Message Navigator

Search logic failure &other stuff [message #8832]

Tue, 25 February 2003 17:42

macaran

Messages: 1
Registered: November 2002

Karma:

Junior Member

Hey guys, it might be worth skipping look&feel stuff like icons and other silly requests and do something about the real functionality. Smile

I understand that FUDforum is not a typical commercial app, but even then..
For example try searching these forums for "help problem feature php" with OR logic. You get 40 rows per page and the pager at the bottom is lllooonnngg.. But try clicking any of the pager's links..

Don't get me wrong, your indexing system is quite impressive, it only needs totaly different search logic than you have now.

Using a few simple (up to 3x NATURAL JOINs) SQL queries, your indexing logic gives nice and accurate results even on complex searches.
But first, forget the search as it is now. Smile

Sorry for criticizing.. only trying to help you uncover what needs to be fixed. Smile

- Mac

P.S. Maybe adding a 'forum_id' into {SQL_PREFIX_TABLE}msg table would save one JOIN on the search query - this way you have to do JOIN on ~msg[thread_id],~thread[forum_id] when trying to limit search to a single forum.

Report message to a moderator

[Message index]

		Search logic failure &other stuff By: macaran on Tue, 25 February 2003 17:42
		Re: Search logic failure &other stuff By: Ilia on Tue, 25 February 2003 19:32

Previous Topic:	3-letter-usernames!!
Next Topic:	Brake row location

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 15:01:17 GMT 2025

Total time taken to generate the page: 0.03353 seconds