on 02-11-2004 3:36 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.