TechFlask

Blog about Software, Life and anything between them

Search...
  • Protect the Island Game
  • Blog
  • About me

TechFlask

Close

Optimization

LINQ: Where vs Join

It is very important to understand difference between WHERE and JOIN operation. WHERE is actually create a Cartesian product, meaning if you working on two tables (Table1 has 100 rows and Table2 has 1000 rows), WHERE condition will evaluates on 100*1000 rows. In contrary JOIN will takes rows from Table1 and will take only matching… Continue Reading

July 21, 2016 jviaches .NET, Development, Optimization
Continue Reading

Social Links

  • 4comments
  • 67posts
  • 0users
  • 0followers
  • 0subscribers

Popular

Recent

Random

  • Offline mode or little game of Chrome

    August 4, 2016 2 Comments
  • Andoid DDMS – how to use it in IntelliJ

    February 15, 2012 2 Comments
  • Mantak Chia: Techniques to Activate The Second Brain

    January 23, 2019 Leave a comment
  • Mantak Chia: Techniques to Activate The Second Brain

    January 23, 2019 Leave a comment
  • Wake up call – Motivational video

    November 19, 2018 Leave a comment
  • Raise your standards – Robby Robins

    August 30, 2018 Leave a comment
  • Blog design is updated

    January 12, 2015 Leave a comment
  • Get image relative source in WPF

    January 25, 2012 Leave a comment
  • Step by step Dependency Injection tutorial with Ninject

    January 13, 2016 Leave a comment
Copyright TechFlask.com @ 2013