I Have One Table (My Sql) with 2 millions records and one List with 100 Records. I have List Except lamda expression for finding all those Urls that is in List but Not in Table.

Now Issue is that it's taking lot of time around 5 mins. I am working in powerful VPS and code and database in same server.

Please suggest me All possible way to increase the performance of linq to sql and linq to entity.

My Code Is`return 

Urls.Except(DbContext.postedurllists.Select(crawl => crawl.PostedUrl).ToList()).ToList();`

Where Urls Is List Which Contain 100 Urls And postedurllists is a table that contains 2 Millions record. Thanks

mysql sql linq-to-sql list linq-to-entities
Edit
Report