Performance Tip

[Former Member]

Hi all!

We are designing an app in .Net. And we are doubting between read user tables with .NET datasets or with SAP recordsets.

With .NET datasets the problem is that we are opening another connection with db. But it has a lot of benefits for us because we are using strongly tiped dataset and we use it to pass a lot of information between objects.

My question is. It`s recomended use datasets or recordsets? And what amount of performance we loose using datasets?

Thanks

[former_member185703 · Accepted solution]

Hi Javier,

SAP (i.e. DI API) Recordset has not been designed for maximum performance. I.e., it might even be faster to use .NET datasets, but I never tried.

It depends on how often you need to read the data (+ how many + for what purpose) vs. opening another DB connection (=> need credentials etc.) to find out what is faster - or suitable.

You really need to check in an environment which reflects the customer scenario.

It could happen that you find out that the .NET way is significantly faster, but I don't know.

Regards,

Frank

[Former Member]

I tried the 2 way ... and, for user tables, I think the better solution is using datasets.

Recordsets are not a optimized for massive operations.