»Spread COM  » Product Tour  » Virtual Mode

jump to: - select feature - Welcome to the Spread COM... Sample Application Scenar... Customer / Order Lookup Card-View Custom Grid Aged-Receivables Report Query Builder Hierarchy / Tree View Print / Print Preview Adding Data Bound Mode Bound Mode: Cell Types Bound Mode: Rows and Colu... Unbound Mode Virtual Mode Working with Data Cell Types Appearance Cell Notes / Text Tips Formulas Sorting Locking Cells Operation Modes Updating / Exporting Data Updating Your Database Exporting Files Printing / Report Writer Print Preview Print Multiple Items Printing Options Spread Designer Conclusion Please take a moment to r...

Virtual Mode

You have 300,000 rows of data you need to display in a grid. Loading this in memory will take a long time to read and display, thus making your customer wait during this entire process. That is if your current grid will even support this much data.

Using Spread’s Virtual Mode, the display time will be much faster, and the Spread control supports up to two billion rows and two billion columns.

Virtual Mode allows Spread to hold in memory and buffer a limited number of records at any given time. This feature greatly decreases the amount of time it takes to populate the spreadsheet, giving your customer a prompt display of your data.

For example, you can specify that you want to load and display one screen’s worth of data at any given time. Spread will fetch and display this data. When the user scrolls up or down, Spread will request the additional data and display it at that time. Your application no longer needs to load an entire file into memory at one time, which means a faster application and happier customers.

Use the special scroll bars for easy navigation.