You need to turn use some debugging tools to help you identify the key
culprits. For example, if your query to check if a user has unsubscribed is
taking 500ms, that alone would be the reason for the slowness.
Either use the step debugger, a tool like FusionReactor or just turn on
verbose
I'm still fighting with my Excel Import application a
bit. Basically, it works pretty well, as long as
there's a limited number of records being imported.
Was testing last night with the 15,000 record Excel sheet.
If I comment out the two filter queries in the code, it will read in the
Do you have indexes on ml_email and groups_id columns? I would likely
create an index that has both in it.
There's a couple of suggestions about changing your architecture a bit:
First, from the looks of it I think you could probably combine both these
queries into one with a left join
Any chance to have the database engine do all that record logic? That would be
the first thing I would try. Stored procedures are great for things like this.
I don't know what RDMS you are using, but most have SQL that can do this.
Complex database stuff is usually better off doing within the
On 11/15/2014 12:42 PM, Roger Austin wrote:
Any chance to have the database engine do all that record logic?
After killing myself on this, I finally realiaed I was doing it ALL
WRONG! All those loops and everything to filter the array, then do the
insertwas taking forever.
I'm revising - BULK
You might try something like this
SELECT *
FROM t1
WHERE NOT EXISTS
(SELECT * FROM t2 WHERE t1.email = t2.email);
Without being more familiar with your use case, it is very difficult to suggest
much.
Les Mizzell lesm...@bellsouth.net wrote:
On 11/15/2014 12:42 PM, Roger Austin
6 matches
Mail list logo