Data Relation Performance

[raja]

Hi,
I would like to know what performes better,
(a) Creating datasources for each table (like Order and OrderDetails) and Relating them using Data Relation
or
(b) Writing a query by myself (that has all the joins and stuff) to get the same result with out using Data relation of Stimul.

I have a feeling (b) performs better. Any one know the internals of Stimul's Data Relation?

Thanks in advance!!!

[Vital]

Hi,
I would like to know what performes better,
(a) Creating datasources for each table (like Order and OrderDetails) and Relating them using Data Relation
or
(b) Writing a query by myself (that has all the joins and stuff) to get the same result with out using Data relation of Stimul.

I have a feeling (b) performs better. Any one know the internals of Stimul's Data Relation?

Thanks in advance!!!

StimulReport engine use standard ADO.Net data relations. So you will receive speed equal to any other ADO.Net datarelations from DataSet. If you don't have any troubles with writing one query instead many tables you can use it - this way is more better.
Thank you.

[raja]

Hi,
I would like to know what performes better,
(a) Creating datasources for each table (like Order and OrderDetails) and Relating them using Data Relation
or
(b) Writing a query by myself (that has all the joins and stuff) to get the same result with out using Data relation of Stimul.

I have a feeling (b) performs better. Any one know the internals of Stimul's Data Relation?

Thanks in advance!!!

StimulReport engine use standard ADO.Net data relations. So you will receive speed equal to any other ADO.Net datarelations from DataSet. If you don't have any troubles with writing one query instead many tables you can use it - this way is more better.
Thank you.

Thanks for your quick response. So if I understand you correct, option (b) performs better than (a). Let me know if I am wrong. Thanks!!!

[Guest]

Yes, option (b) better for perfomance than option (a).

Thank you.