Dataset table adapters

Can someone tell me why when I first execute the tableAdapter to GetData() or Fill (), It takes along process time to give back data. It only happens the very first time. But the thing I don't understand is After the first execute of any tableAdapter I call, it works or run much faster. Its always the initial execute.

Can someone assist me.

The logic I am using is below:


  var List = from s in this.colorTableAdapter.GetData()
  select s;

  ColorSerialPartNumberComboBox.DataSource = List.Select(t => t.colorSerialNumber).ToList();

The reason for this is that the first time you retrieve data, it starts from scratch and does a complete round trip to the server. The next time you want to retrieve data, it just refers to the local (cached) copy instead of performing a round trip. This is the reason why this architecture is also called disconnected architecture, as it often makes use of the disconnected (cached) copy of data lying with it. Even you modify data, unless you call AcceptChanges() and SubmitChanges() the modifications will not be seen on the actual database on the server, they will be local-only.

Hope that made sense, if not, please ask some more. Would be glad to discuss on this.

Thats understood.  so is there a way to speed up the performance the first time around. because sometime the first takes a along time and then sometimes it doesnt its not consisitent at all.

what to do , to make  pulling data faster. i want my query to work as fast as mananagement studio lololol, its consistent every time. lolol how to get speed performance