AdomdDataReader vs. SqlDataReader Performance

[Phil]

I am looking into converting a .NET SQL Server
Software application to a .NET Analysis Server
Software application. I know MDX is faster than
T-SQL but what is the performance comparison
between SqlDataReader and AdomdDataReader.
I would say the SqlDataReader is probably
faster but by how much. I know ADOMD.NET
is still in early beta but has anyone
done the performance comparisons. It would
also help if a study included the OleDbDataReader
as well.

 

[William Ryan]

I can't speak to the ADOMD difference, but this is a
pretty thorough test done between OLEDB and SQLClient...

http://www.vb2themax.com/HtmlDoc.asp?Table=Articles&ID=510

If I come across anything, I'll post it.

Good Luck,

Bill

W.G. Ryan
(e-mail address removed)
www.knowdotnet.com