+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Keyword search through text DB fields (/showthread.php?tid=11247)
Pages:
1
2
Keyword search through text DB fields - El Forum - 09-02-2008
[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?
Keyword search through text DB fields - El Forum - 09-02-2008
[eluser]drewbee[/eluser]
Well, from personal experience I can highly recomend .
http://framework.zend.com/manual/en/zend.search.lucene.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)
Keyword search through text DB fields - El Forum - 09-02-2008
[eluser]parrots[/eluser]
@Daniel Yep, that's how I addressed that concern, no way I'd want to do that manually in my code.