Mountain View 1600, CA 94043
+1 650-253-0000
name@example.com
Web
Site
Search
Register
Login
DNN Home
Services
-
DotNetNuke Support
-
CRM Systems
DNN
-
DotNetNuke Modules
-
Module Downloads
-
Module Upgrade Policy
DNN Support
-
Module Update News
-
Knowledge Base
-
License Management
-
Invoice History
Module Downloads
Blog
Store
Contact Us
-
About Us
Search
Home
1
2
3
4
5
Home
Support
Bulk Emailer
Bulk Mailer crushing SQL
Previous
Next
8/13/2015 1:14 AM
Richard
Joined: 10/21/2009
Posts: 20
Bulk Mailer crushing SQL
(South Africa)
Hi Team,
The following SQL is running over and over and at each pass runs the CPU up to around 80%. In some cases it goes to 100% and the site App Pool closes down. I then have to restart the app pool to get the site back online:
SELECT ItemId, JobItemId, Attempted, FullName, Email, LastFailed, LastFailedReason, LastAccessed, IsCompleted, InUse,SMTPServer,NextStart,CampaignGroupId,BatchId
FROM iwebs_BE_JobDetail
WHERE JobItemId = @JobItemIdCurrent and LastAccessed>'2000-01-01' and
( LOWER(Email) not in (SELECT LOWER(Email) FROM iwebs_BE_JobDetail WHERE JobItemId = @JobItemIdNext ) )
Please help me solve this issue.
Regards,
Richard
Page 1 of 1
Previous
Next
Home
Support
Bulk Emailer
Bulk Mailer crushing SQL