The benefits of using a live connection over an extract include:
B: A live connection ensures that the data in the workbook is as up-to-date as the database itself, providing fresher data compared to a static extract which is updated at intervals.
C: A live connection queries the database server directly, which means it uses the server's memory and processing power rather than relying on the client computer's resources.
A live connection does not necessarily require less network overhead (A) as it may continually send queries over the network, and it is not always faster than an extract (D) because extracts can provide quicker response times for complex queries or large datasets.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit