title: Blob data fetching is too slow
body: <p>I'm storing 180 tiled image data into MySQL database. Each tiles about 10KB.</p>
  
  <p>When I try to fetch ALL of the tiles from the MySQL database with ONE connection and SINGLE query, it takes 200ms and it is very slow for me.</p>
  
  <p>Is there any way to make it faster?</p>
  
  <p>This is my "<strong>filedata</strong>" table. (I've tried MyISAM and INNODB. Result is the same :()</p>
  
  <pre><code>id (int) **PrimaryKey**
  layerid (int)
  channelid (int)
  stratumid (int)
  x (int)
  y (int)
  tiledata (MEDIUMBLOB)
  </code></pre>
  
  <p>And this is my console application for testing the query.</p>
  
  <pre><code>Console.ReadKey();
  
  Stopwatch swx = new Stopwatch();
  swx.Start();
  
      MySqlConnection conn = new MySqlConnection("Server=127.0.0.1;Port=3306;Database=trying;Uid=root;Pwd=;Encrypt=false;AllowUserVariables=True;UseCompression=True;");
      conn.Open();
  
  
  Console.WriteLine("Connection open.");
  
  swx.Stop();
  
  Console.WriteLine("Conn Open Time = " + swx.ElapsedMilliseconds.ToString());
  
  Console.ReadKey();
  Stopwatch sw = new Stopwatch();
  sw.Start();
  MySqlCommand com = conn.CreateCommand();
  com.CommandText = "SELECT filedata FROM filedata where layerid = '5'";
  MySqlDataReader reader = com.ExecuteReader();
  while (reader.Read())
  {
      byte[] b = (byte[])reader[0];
  }
  reader.Close();
  sw.Stop();
  Console.WriteLine("Time= " + sw.ElapsedMilliseconds.ToString());
  Console.ReadKey();
  </code></pre>
  
  <p>My computer is;</p>
  
  <p>Processor: i7 2,67 Ghz,
  RAM: 6 GB,
  HDD: 1 TB SSD.</p>