cancel
Showing results for 
Search instead for 
Did you mean: 

UI: Slow Matrix

Former Member
0 Kudos

Hello,

I have implemented all SAP recommendations for fast load of matrices. However my matrix still takes 12 seconds to load (100 rows / 8 columns ).

Anybody has experience with matrices performance?

thanks

Marcos Sola

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Marcos,

are you using dbdatasources and userdatasources to get the data, or are you "writing" the data in the matrix via the cells?

The first option is much faster than the second with us. We are displaying the content of a userdefined table.

The problem we still have is that we do not know how to write back to a userdefined table via DIAPI. There does not seem to exist a userdefined table object with an update method of some sort.

HTH Lutz Morrien

kurt_huwiler
Participant
0 Kudos

Hi Marco, Hi Lutz

I have a project where I create UserDefinedTables using the SDK.

For adding records to this tables, I use the recordset object of the DataAPI.

For example

INSERT INTO [@Bir] VALUES('00000006','000000000000000000000000000006','B200','A00002')

Regards

Kurt

Former Member
0 Kudos

I use the first option, userdatasources (as recommended by SAP).

For example, this code takes 12 seconds:

    Dim i As Integer

    For i = 0 To 200

    tUserDataSource1.Value = i + 1

    tUserDataSource2.Value = i + 1

    tUserDataSource3.Value = i + 1

    tUserDataSource4.Value = i + 1

    tUserDataSource5.Value = i + 1

    tUserDataSource6.Value = i + 1

    tmatrix.AddRow

    Next

    tmatrix.AutoResizeColumns

Former Member
0 Kudos

Kurt,

is this the only option you know of?

We realized that this is a way of adding data to tables... but the recordset deifinition indicates that it really is only meant for queries.

strQuery="INSERT INTO [@Bir] VALUES('00000006','000000000000000000000000000006','B200','A00002')"

recordset.DoQuery(strQuery)

It does work. But what if SAP changes functionality of the DoQuery method to just allow queries?

I'd rather have a recordset.DoInsert or recordset.Update.

I guess we hav to live with it until SBO version 8.0 or something like that

Thanks, Lutz