Returning fastes datastructure...

  • Thread starter Thread starter Anders S. Willumsen
  • Start date Start date
A

Anders S. Willumsen

I need to return a fast datastructure from our datalayer (connected to a
SQL-server) to middletier. What is the fastes one avalible? I'm don't think
a can return a datareader (midd.layer might not close the reader) - but what
can I use instead:

Multid. array?
Dataset?
Datatable?
Dataview?
XML (from dataset)?

Hope you can help!
 
Fastest? Probably putting the values in an array. Is it that much
faster than loading to a simple DataTable? Not really. I'd
only utilize this approach if you needed every last drop of
performance for that specific query.
 
Back
Top