Matthew Woolnough 10 years ago in UNIFYBroker/eMinerva • updated by anonymous 8 years ago • 6
Boyd has asked me if the eMinerva connector could work without paging.
It appears the Web Services written for eMinerva does not perform paging efficiently and would like to know if they can get rid of it completely rather than try and fix it.
Customer support service by UserEcho
Hi Matthew, a few questions:
2. We want to know if the connector will handle this prior to changing the Web Service code.
3. Boyd has told me that the SQL query behind the Web Service runs once for each page of data sent over the wire, rather than running a single query, compiling the results and feeding them out over the wire as paging allows.
Regarding 2, if the page size is increased in the connector, it will only need to make the call once. Has this been tried?
Regarding 3, SQL Server is not the only consideration. There are other things to consider when transferring large amounts of data, such as WCF.
Another point I should have made is this: Is there a noticeable problem that has triggered this issue? If the connectors are meeting the non-functional requirements is there really a need to explore other options?
It sounds as though the answer is yes; the connector will handle it by extending the page size to a very large number, however WCF may have timeout issues and so this approach is not recommended.
Yes, the connector supports a larger page size. And yes, timeouts may be an issue. This is similar to the issues that may be experienced if the WCF endpoint is changed to not page, if not done correctly.
Thanks, I'll pass that information on.