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 Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to