.NET Scaling project : <p>What would be better in terms of speed for a far larger database between these two? they don't have to talk to their foreign key counterparts because a loop will occur sending an email from the table and deleting the entry so there be no view. I don't know if having the foreign keys and getting it to read each time but only storing a fraction of the data, or storing the data again and not having it read other tables?</p>

<pre><code>namespace Linkofy.Models
{
public class AutoSending
{
    public int ID { get; set; }

    [Display(Name = "Receipiant Name")]
    public string receiptName { get; set; }

    [Display(Name = "Receipiant Emial")]
    public string receiptMail { get; set; }

    [Display(Name = "Sender Name")]
    public string senderName { get; set; }

    [Display(Name = "Email Address")]
    public string emailAddress { get; set; }

    [Display(Name = "Password")]
    public string password { get; set; }

    [Display(Name = "Send subject")]
    public string subject { get; set; }

    [Display(Name = "Send body")]
    public string Body { get; set; }

    [Required(ErrorMessage = "Send Time")]
    public DateTime sendDate { get; set; }

    public int autoListID { get; set; }

    public int? UserTableID { get; set; }
    public virtual UserTable UserTable { get; set; }
}
}


namespace Linkofy.Models
{
public class autoList
{
    public int ID { get; set; }

    public int? OutreachNamesID { get; set; }
    public virtual OutreachNames OutreachNames { get; set; }

    public int EmailAccountID { get; set; }
    public virtual EmailAccount EmailAccounts { get; set; }

    public int TemplateID { get; set; }
    public virtual Template Templates { get; set; }


    [Required(ErrorMessage = "Emails Sent")]
    public int sent { get; set; }


    [Required(ErrorMessage = "Total to Send")]
    public int total { get; set; }


    [Required(ErrorMessage = "Start Date")]
    public int startDate { get; set; }


    [Required(ErrorMessage = "End Date")]
    public DateTime endDate { get; set; }

    public int? UserTableID { get; set; }
    public virtual UserTable UserTable { get; set; }
}
}
</code></pre>
