Performance Issues entity framework with query
<p>I am currently working on this query in EF 6.</p>

<pre><code>using (var metadata = new DMSEntities())
{
    var q = from row in metadata.db_Patient orderby row.Name
                    where !row.isDeleted where row.FileLocation.StartsWith(SearchTerm)
                    || row.Name.StartsWith(SearchTerm)
                    || row.Surname.StartsWith(SearchTerm)
                    || row.IDNumber.StartsWith(SearchTerm)
                    || row.Initials.StartsWith(SearchTerm)
                    select new bl_Patient
                    {
                        Name = row.Surname,
                        Surname = row.Name,
                        IDNumber = row.IDNumber,
                        Initials = row.Initials,
                        Location = row.FileLocation,
                        patientID = row.patientID
                    };

    var FCount = q.FutureCount();

    var Results = q.Skip(Paging.Skip).Take(Paging.Take).Future();

    var Count = FCount.Value;
    var TotalPages = Count / 10;

    if (TotalPages!= 0 &amp;&amp; Count % TotalPages != 0)
    {
        TotalPages = TotalPages+1;
    }

    Paging.TotalPages = TotalPages;

    return Results.ToList();
}
</code></pre>

<p>Is there anyway to increase performance. I do not have access to sql studio so creating views or stored procedures will not work. On my test machine, everything works fine however on the clients much slower laptop it hangs on first load. Any help would be appreciated.</p>

<p>Edit: I see my question has been set on hold so let me see if I can clear up some things.</p>

<p>First of all this is a windows forms application I created to help out one of my friends. Database and application is ran from a single machine. I use SQL server. There was no requirements agreed on by me or client as it was just done as a favor. The laptop has a dual core 2.4ghz and 4 gb of ram and is about 4 years old. I asked the question because I wanted to know if there is any other tips that can be given. I have explained to the client that there is no real way to improve performance as the real problem is the laptop. We have found ways around the Issue and the client can use the application now. Also just so you guys know I only have about a year and half development experience so I asked this question more to increase my own skill then solving the actual issue.</p>

<p>More information regarding what I have changed. </p>

<p>I have implemented a 3 letter minimum on the search items. This has mostly solved the Issue. </p>

<p>I also added some indexing as a have never really done this before and had to go read up on this. </p>

<p>The database has about 4000+ items, it does still hang sometimes however it is now less prone to crashing and completely usable. </p>

<p>For the background of the app it is simply to manage Patients and the location of there folders. I only posted this one query as this was the only one giving issues. There is no other list methods. </p>