Hi,
I did some experimenting with the Dashboard component using the online docs and my own (SQL Server 2008) database. Based on my experience I have some questions:
- The component just stops with an out of memory error when querying a 700.000 records tables during the initial load determining the fields. why do not something like a 'top 1' , 'where 1=0' or whatever modification so the fields list can be retrieved in sub-second times?
- If the problem mentioned at 1) gets solved will we then run into the problem that the query times out when retrieving the data for manipulation in (e.g.) a pivotgrid? If so, what/who is the intended audience of this functionality (taking the number of records it can handle as a measure)?
regards
Martin