I am currently developing integration solution using 'e-conomic' .NET API. Basically, it is a reporting tool which queries lots of data from related objects. For example, I have a report which shows lists of top customers, top employees, top products etc. It is almost identical to the info that is displayed on the 'Sales' tab in 'e-conomic' web-interface
The point of concern is performance of data retrieval. I use fetch classes like 'IDebtorData' and for some reports performance is quite good. But when I build a report by products there are too much round-trips:
1. Getting 'IProduct' array
2. Getting 'IProductData' array
3. Getting 'IInvoiceLine' for each product
4. Getting 'IInvoiceLineData' for each 'IInvoiceLine'
Maybe somebody can suggest a better flow, but what is interesting for me is the following
I notice that in web-interface (for example 'Top customers' list) all the info is updated immediately. I assume this is because ASP pages use database queries (join, sum, sort etc), which allow to retrieve the data extremely fast
So, my question: is there some way of making such sort of quieries through .NET API or SOAP? I looked through the documentation and haven't found an answer. If this is not supported, do you consider it is possible to have something similar in the future?
Thanks in advance