EmailSend: Load `cdi_campaignid_Name` as Campaign_Name, `cdi_fromname` as ES_From, `cdi_openscount` as ES_OpenCount, Date(`cdi_senton`) as Datum, `cdi_subject` as ES_Subject, `Id` as `cdi_emailsendid_Id` Resident TempEmailSend Where statuscode = 'Sent';
Drop Table TempEmailSend;
TempEE: SQL SELECT `cdi_emailsendid_Id`, `cdi_type` as EE_Type, `cdi_url` as EE_URL, "cdi_time" as EE_Date FROM .....`_emailevent` Where Exists (cdi_emailsendid_Id);
Connector reply error: SQL##f - SqlState: 42000, ErrorCode: 4294967295, ErrorMsg: Malformed SQL Statement: Expected token 'FROM' but found 0 with value 'Id' instead at position 222. Statement:SELECT `cdi_emailsendid_Id`, `cdi_contactid_Name` as Contact_FullName, `cdi_type` as EE_Type, `cdi_url` as EE_URL, "cdi_time" as EE_Date FROM CData.DynamicsCRM.`cdi_emailevent` Where Exists (Id, cdi_emailsendid_Id)
exists itself is quite memory consuming. In other hand you can put your Exists into SQL and leave the job to be done by DB, but I am not sure whether that would decrease reload time or not. Maybe use 64bit connector instead of 32bit (if you do not so and if it is possible), try to reduce number of fields to minimum...but this is more like general advice you are probably aware of...
ECG line chart is the most important visualization in your life.