Slowness in adding data to a Matrix
Hello to all
I'm adding it data to a matrix from a Query, are 10.000 items in total, but does it take a lot of time in writing in the matrix, 7 minutes approximately in development atmosphere, How I can reduce this time?
I'm working with sbo 2005
Louis de Gouveia replied
Hi Hector Olmos
There is three options
1) To speed it up you should use a dbdatasource for your matrix. Bind the dbdatasource to your matrix, this is usualy quicker. But sometimes you are limited especailly if you need data from more than one table. If you need data from more than one table this is not your solution.
2) When loading the matrix, if you are putting the values cell by cell that will take longer than doing it through the datasource. So load through the datasource. slightly quicker.
3) Use SBO new grid option, the grid allows you to link a query to it, the grids will then load it by it self. I think this will be your best option.
Hope this helps