datatables vs. arrays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
When I have to cache in data from static tables in our SQL
server database, what would you recommend? datatables or
arrays? I find datatables easier to work with. But, I need
to know if there are any overheads, performance issues
etc. in using datatables and also if traversing arrays is
faster, more efficient etc. Kindly post your thoughts and
experiences.
Thanks in advance.
 
Hi,

I would go with DataTables because they are easier to use, more powerful and
don't have that much overhead.
 
I would recommend going with custom objects,as they are easier to use, more
powerfull and have WAY LESS overhead than the terribly bloated DataTables.

--
Regards

Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)
(CTO PowerNodes Ltd.)
---

Still waiting for ObjectSpaces? Try the EntityBroker today - more versatile,
more powerfull.
And something in use NOW. for the projects you have to deliver - NOW.


Miha Markic said:
Hi,

I would go with DataTables because they are easier to use, more powerful and
don't have that much overhead.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Hi all,
When I have to cache in data from static tables in our SQL
server database, what would you recommend? datatables or
arrays? I find datatables easier to work with. But, I need
to know if there are any overheads, performance issues
etc. in using datatables and also if traversing arrays is
faster, more efficient etc. Kindly post your thoughts and
experiences.
Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top