title: subsonic - collection load versus query
body: <p>I am setting the data source of a datagridview to a subsonic collection</p>
  
  <pre><code>        TcolorCollection tc = new TcolorCollection().Load();
          dataGridView1.DataSource = tc;
  </code></pre>
  
  <p>and I've noticed that the previous code is much (way to much) slower then the following</p>
  
  <pre><code>        SubSonic.Query q3 = new SubSonic.Query("tcolor");
          q3.QueryType = SubSonic.QueryType.Select;
          IDataReader reader = q3.ExecuteReader();
          DataTable dt = new DataTable();
          dt.Load(reader);
          dataGridView1.DataSource = dt;
  </code></pre>
  
  <p>I would like to use the collection class and it's connectivity, but I need a way for the .Load() to be faster.</p>
  
  <p>fyi the table I am using has 8000+ records. Not small, but not huge either.</p>