Hello symfony users :) ,
I just started use off symfony framework and very great work I would
say, but...
I have some performance issue when inserting more than 1000 records to
database it very too long!!!
I just tested from Doctrine created object:
public function executeGo(sfWebRequest $request)
{
...
foreach (...)
{
$queue = new Queue();
$queue->client_id = $record['client_id'];
$queue->mark = '0';
$queue->email = $oneemail;
$queue->save();
$queue->free(TRUE);
}
...
}
It take me for 10 minutes to complete 3994 records
Then I try plain SQL insert:
INSERT INTO "public"."queue" ("id", "client_id", "email", "mark",
"sent_mail_date_time")
VALUES (4960, 2499, '[email protected]', 0, NULL);
...
It's take me 0.04 sec to complete 3994 records.
I using default everything as described in documentation 1.2 version.
who can help me about this issue? Maybe I have to make some options
changes some where?
Tadas
P.S. I using PostgreSQL 8.3 .
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
