By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,967 Members | 1,684 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,967 IT Pros & Developers. It's quick & easy.

Best Search App

P: n/a
I was wondering what would be the best search application for indexing/
searching content? Fulltext in MySQL is too slow once you get a db
over 1GB. I played around with Zend's version of Lucene, but it
contains a few bugs that need to be fixed before I can use it..

Does anyone know of other search libs/apps out there that would work
well with php?
Sep 10 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
neoform wrote:
I was wondering what would be the best search application for indexing/
searching content? Fulltext in MySQL is too slow once you get a db
over 1GB. I played around with Zend's version of Lucene, but it
contains a few bugs that need to be fixed before I can use it..

Does anyone know of other search libs/apps out there that would work
well with php?
You aren't going to get much better than a database. Even Lucene is
going to be slow with over 1GB of data.

Maybe you need to look at optimizing your database. Try
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Sep 10 '08 #2

P: n/a
Actually, I the reason I switched was because mysql's built in text
search was too slow. There isn't much in terms of tuning that can be
done to make it faster.. Plus I was told that lucene is actually
faster than mysql for that sorta thing. I've created my own search
db's in the past, but they were never very accurate (though they were
fast).

On Sep 10, 3:18*pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
neoform wrote:
I was wondering what would be the best search application for indexing/
searching content? Fulltext in MySQL is too slow once you get a db
over 1GB. I played around with Zend's version of Lucene, but it
contains a few bugs that need to be fixed before I can use it..
Does anyone know of other search libs/apps out there that would work
well with php?

You aren't going to get much better than a database. *Even Lucene is
going to be slow with over 1GB of data.

Maybe you need to look at optimizing your database. *Try
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Sep 10 '08 #3

P: n/a
neoform wrote:
On Sep 10, 3:18 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
>neoform wrote:
>>I was wondering what would be the best search application for indexing/
searching content? Fulltext in MySQL is too slow once you get a db
over 1GB. I played around with Zend's version of Lucene, but it
contains a few bugs that need to be fixed before I can use it..
Does anyone know of other search libs/apps out there that would work
well with php?
You aren't going to get much better than a database. Even Lucene is
going to be slow with over 1GB of data.

Maybe you need to look at optimizing your database. Try
comp.databases.mysql.
Actually, I the reason I switched was because mysql's built in text
search was too slow. There isn't much in terms of tuning that can be
done to make it faster.. Plus I was told that lucene is actually
faster than mysql for that sorta thing. I've created my own search
db's in the past, but they were never very accurate (though they were
fast).
There are a number of things you can do to optimize your database. They
may or may not help. Check comp.databases.mysql.

But I say again - searching 1GB of text for keywords is going to be
slow, no matter how you do it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Sep 10 '08 #4

P: n/a
Hi,

neoform wrote:
Does anyone know of other search libs/apps out there that would work
well with php?
Indexdata's (http://indexdata.dk/) Zebra search engine works pretty
good for me. You'd use PHP/Yaz (in PECL) to communicate to it.
However, it might need more insight than you may be willing to spend
time for. However it is a fine full text search engine and works fine
with XML data. The mailing lists for Zebra and Yaz are supportive and
in the worst case you can hire support from the creators (it's GPL
software, of course).

-hwh
Sep 11 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.