• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Keyword search through text DB fields

#11
[eluser]Daniel H[/eluser]
Hmm yeah maybe I just worry about reconciling the tables. Do you use a trigger to keep the two in sync?

#12
[eluser]drewbee[/eluser]
Well, from personal experience I can highly recomend .

http://framework.zend.com/manual/en/zend...ucene.html
Full indexing, searching, file based. Uses segments and the like during indexing. If you don't mind dropping in a small piece of the Zend framework on top of CI, have at it. It has no dependencies on any other part of the framework so can be ran as a standalone.

My only issue with the entire setup is that you can't update documents; however you can delete then re-create it. So a tiny bit of an inconvenience, but well worth troubling with. Also it has a maximum segment size of 2GB if you are on a 32 bit system (this is a limitation of the file system, not lucene)

#13
[eluser]parrots[/eluser]
@Daniel Yep, that's how I addressed that concern, no way I'd want to do that manually in my code.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.