Fetch (Big)

Fetch command useful for SELECT queries on large data sets.
531 Downloads
Updated 1 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 (2024). 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
Categories
Find more on Large Files and Big Data in Help Center and MATLAB Answers

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes
1.1.0.1

Updated license

1.1.0.0

Added a note that this file is unnecessary in r2013a and later, as the functionality is now built in.

1.0.0.0