image thumbnail

Fetch (Big)

version 1.1.0.1 (3.26 KB) by Tucker McClure
Fetch command useful for SELECT queries on large data sets.

523 Downloads

Updated 01 Sep 2016

View License

This fetch command is useful for SELECT queries on large data sets. First, it runs a query to determine the number of rows being returned, then preallocates the space necessary for the input query's result, then runs the main query, fetching the results in batches.
This allows pulling much more information from a database in a single query than the built-in methods (by using batches to avoid using too much of the Java heap) and does this much faster (by preallocating space for the output).

Note for r2013a: This functionality is now built into the 'fetch' command in the Database Toolbox. See the documentation for that command.

Cite As

Tucker McClure (2022). Fetch (Big) (https://www.mathworks.com/matlabcentral/fileexchange/36367-fetch-big), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2012a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!