Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (57-Vette, Chosen), 43 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 03/24/10
Posts: 8
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#233893 - 01/18/10 07:27 AM Will there be any indexing engine incorporated in the future ?
smallufo Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Taiwan
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.


Edited by Gizmo (01/18/10 11:20 AM)
_________________________

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.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#233901 - 01/18/10 11:57 AM Re: Will there be any indexing engine incorporated in the future ? [Re: smallufo]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
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..
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#233910 - 01/18/10 04:02 PM Re: Will there be any indexing engine incorporated in the future ? [Re: SD]
smallufo Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Taiwan
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.
Top
#233911 - 01/18/10 04:12 PM Re: Will there be any indexing engine incorporated in the future ? [Re: smallufo]
Philipp Offline
journeyman
Registered: 07/30/06
Posts: 82
Why not using Sphinx?
Top
#233913 - 01/18/10 04:19 PM Re: Will there be any indexing engine incorporated in the future ? [Re: Philipp]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#233914 - 01/18/10 04:47 PM Re: Will there be any indexing engine incorporated in the future ? [Re: Rick]
smallufo Offline
enthusiast
Registered: 06/05/06
Posts: 265
Loc: Taiwan
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.
Top



Moderator:  AllenAyres, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image