Efficiently fill resultset in object model
Posted
by Zeeshan
on Stack Overflow
See other posts from Stack Overflow
or by Zeeshan
Published on 2010-05-20T08:47:19Z
Indexed on
2010/05/20
8:50 UTC
Read the original article
Hit count: 150
Hi,
I have an object model whose structure is
Dashboard
List of panels
List of containers
List of widgets
If i get whole dashboard, with panels + containers + widgets, from Database then multiple I/O requires
I want to get it in one I/O .For this i prepared a query which gives me this resultset.
DASHBOARDID PANELID CONTAINERID WIDGETID
13 11
5 2
13 11
5 3
13 11
6 4
13 11
6 5
13 12
7 6
13 12
7 7
13 12
8 8
13 12
8 9
Using list datastructure this model is able to be filled but it takes time i want to efficiently fill this resultset in above object model. is there nay way ?
© Stack Overflow or respective owner