perfomance question

[majorone]

hello, i am trying to design a method in manipulating data over the
intranet, and i am wondering which of the following design can get
better performance.
can u help me? thanks.


<<design 1>>
A DataTable object which contains 4 columns for each row:
id (int), columnA (string), column B (string), column C (string)


<<design 2>>
A generic List<myData> which contains a list of MyData object.

class MyData{
int id;
string columnA;
string columnB;
string columnC;
}

 

[John Timney \(MVP\)]

Having never tried it, I would guess that using a datatable directly with
your data would be faster as you wont have any object casting to do.
Perhaps you should run a small test to find out.

Regards

John Timney (MVP)

 

[Mike Lowery]

You might also want to consider using a Struct instead of a Class.

 

[bruce barker \(sqlwork.com\)]

the list is faster storage.

-- bruce (sqlwork.com)