Indexing large DB's with Lucene/PHP
Posted
by thebluefox
on Stack Overflow
See other posts from Stack Overflow
or by thebluefox
Published on 2010-04-14T14:51:32Z
Indexed on
2010/04/14
14:53 UTC
Read the original article
Hit count: 274
Afternoon chaps,
Trying to index a 1.7million row table with the Zend port of Lucene. On small tests of a few thousand rows its worked perfectly, but as soon as I try and up the rows to a few tens of thousands, it times out. Obviously, I could increase the time php allows the script to run, but seeing as 360 seconds gets me ~10,000 rows, I'd hate to think how many seconds it'd take to do 1.7million.
I've also tried making the script run a few thousand, refresh, and then run the next few thousand, but doing this clears the index each time.
Any ideas guys?
Thanks :)
© Stack Overflow or respective owner