Skip to Content
0

virtual table performance

Jun 21, 2017 at 02:16 PM

30

avatar image

So I'm doing a fairly straight forward create table as select * from sda_virtual table. The performance seems to be a bit meh? Wondering if there is anything I can do either in the create table statement or the config. When I look on the source MSSQL database I see the statement is in "ASYNC_NETWORK_IO" wait which tells me it's waiting on the HANA box. Statement activity is a measly 2-3 MB/sec.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Timo Wagner
Jun 21, 2017 at 08:46 PM
0

Hello Kevin,

I don't know any specifics about SDA but as you've tagged it with SDI you might be interested in testing it out with the Adapter that is using the DPAgent to connect to MSSQL, where we have some more ways of configuring the access. (e.g. Batchsize)

Kind regards,
Timo Wagner

Share
10 |10000 characters needed characters left characters exceeded