Autocomplete [message #618076] |
Mon, 07 July 2014 09:47 |
Duane
Messages: 557 Registered: December 2002
|
Senior Member |
|
|
Can anyone point me in the right direction for implementing a fast table structure for a web autocomplete?
User types in Dentistry Courses
Returned Results
SP2014 Dentistry 101
SP2014 Dentistry 102
SP2014 Dentistry 103
SS2014 Dentistry 101
SP2014 Dentistry 102
.
.
Oracle Text?
TRIE Structure?
|
|
|
|
Re: Autocomplete [message #618084 is a reply to message #618081] |
Mon, 07 July 2014 10:26 |
Duane
Messages: 557 Registered: December 2002
|
Senior Member |
|
|
Not so much the query but design. Would you use multiple tables with keywords that pointed back to the actual table result or a flattened indexed table that used "where course like 'input_value%'"?
I'm looking for something along the lines of:
I would put your major keywords in a table that joined to.... OR This is a case for using Oracle Text with 5 tables that have the keywords and then... OR I've done this before and I used XYZ to implement what I wanted to do and it was super fast and here is what I did.....
[Updated on: Mon, 07 July 2014 10:29] Report message to a moderator
|
|
|