Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 215
enthusiast
enthusiast
Joined: Jun 2006
Posts: 215
Will there be any indexing engine incorporated in the future ?

Depending on SQL's 'like' is very time consuming and resource consumptive , especially there are millions of posts in the DB.
Incorporating 3rd party indexing engine , such as Lucene , can greatly simplify the search job.

Apache Lucene also has PHP bindings.

Last edited by Gizmo; 01/18/2010 12:20 PM.

English is not my native language. I try my best to express my thought precisely. I hope you understand what I mean. If any misunderstanding results from culture gaps, I apologize first.
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
i also would personally love to see ubb.T get away from full-text indexing that myISam offers..

but i'd bet that Lucene would have to be an option as not everyone can just ask their host to install it..

same would go for any other non php/mysql solution..

Joined: Jun 2006
Posts: 215
enthusiast
enthusiast
Joined: Jun 2006
Posts: 215
If Lucene is a little hard , I'd suggest Apache Solr .

Apache Solar is a Lucene's Wrapper , it's like a daemon , which accepts HTTP's POST DATA , and make index of them.
In short , Lucene is programming/API level , while Solr is HTTP level , which accepts any language (just that language able to make HTTP Post).


English is not my native language. I try my best to express my thought precisely. I hope you understand what I mean. If any misunderstanding results from culture gaps, I apologize first.
Joined: Jul 2006
Posts: 116
Likes: 4
P
Member
Member
P Offline
Joined: Jul 2006
Posts: 116
Likes: 4
Why not using Sphinx?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
We certainly can't just tie in to an external option by default because many people won't have access to it. However, we can certainly work on putting in some sort of options for it. Sphinx is one that I've been looking at pretty closely.

Joined: Jun 2006
Posts: 215
enthusiast
enthusiast
Joined: Jun 2006
Posts: 215
I think it can be made an "option"
If the indexing server is setup properly , it will start to grab old posts and indexing old/new posts.
If indexing engine is not set , it will fall back to MySQL's LIKE.


English is not my native language. I try my best to express my thought precisely. I hope you understand what I mean. If any misunderstanding results from culture gaps, I apologize first.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)