We had the same problems, my co-worker managed to find the solution
today. The problem stems from bad garbage collection in the current
version of php and versions less than that. I asked questions on the
propel board and was pointed at about 10 different articles all
pointing to that as the problem. Php is suppose to have a fix in the
next version 5.x version, but that's not expected for a few months.
Our solution is a custom destruct method we had all the Models that
were being indexed extend from this custom class, all the problems we
had went away, including our indexing of 1.4M records from the command
line. We are indexing now and averaging 15MB of memory used for each
index. before at this point it climbed up to 1GB (which I had set the
server too to see if it would just keep going). We had problems with
indexing reviews, when a new review was added when the db contained
the 1.4M records, smaller sets of the data 5000 records worked ok.
Just lots of memory issues all around. Hope the code helps.
James
abstract classYourBaseObject extends BaseObject
{
public function __destruct()
{
foreach ($this as $index => $value)
{
if (is_object($this->$index))
{
if (method_exists($this->$index, "__destruct"))
{
$this->$index->__destruct();
}
else if (get_class($this->$index) == "Criteria")
{
$this->$index->clear();
}
}
unset($this->$index);
}
}
}
On Jun 30, 2008, at 6:01 PM, Carl Vondrick wrote:
>
> On Mon, Jun 30, 2008 at 02:39:48PM -0700, Cristiano wrote:
>> I installed the sfLucenePlugin and added the Propel behaviours as
>> described in the manual. Everything works (I can create an index on
>> the command line, and then search) but when I use actions to create
>> new objects, the on-the-fly indexing goes dead slow and times out.
>> It's really weird because building a new index from the command line
>> on the 10 records goes extremely fast.
>
> Can you provide more information? Can you give me a reproduceable test
> case? What are your system specs? Are you using the production
> environment or dev?
>
> Carl
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
