the relations property defines whether you have to specify the relations manually (property relations: yes) by extending the datasource with the relations you want or if the system should look up the table and type defined relations (property relation: no) to associate the datasources.
Regards
Andreas Gahr
-----Ursprüngliche Nachricht-----
Von: Steeve Gilbert [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 5. Mai 2004 15:18
An: [EMAIL PROTECTED]
Betreff: [development-axapta] Speed up loading of my form
I've created a form similar to InventOnHandItem but with less confusing
dataSource and just the feature we want. The problem is that it takes
to much time to load (~33 seconds) on the live system. The form is
pretty simple. We can strip it down to a grid showing the result of a
view. The view looks like:
InventTable (2753 Records)
|
+(ItemId)-> InventSum (138414 Records)
|
+(InventDimId)-> InventDim (130325 Records)
There's SUM field on almost every field of InventSum. InventDim is
there to be able to search for InventLocationId on the grid. InventTable
is there to be able to search for NameAlias, ItemName, ItemId.
Index :
InventSum has an index on ItemId
InventDim has an index on InventDimId
What's the use of the "Relations" properties on a child dataSource of a
view?
If you have any hint of a clue I'd appreciate it.
Best regards,
Steeve...
Yahoo! Groups Links
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
