Performance Optimization

Optimize your spreadsheet performance for large datasets and complex operations. Learn techniques to maintain responsiveness and efficiency.

Smart Viewport

• Only renders visible rows for instant loading
• Smooth scrolling through millions of records
• Automatic memory management prevents browser crashes

Lazy Loading

• Columns load on-demand as you scroll horizontally
• Background prefetching for smooth navigation
• Intelligent caching of frequently accessed data

Filter Performance

• Indexed filtering for instant results
• Compound filters execute in optimal order
• Filter hints show estimated result counts

Sort Operations

• Multi-threaded sorting for large datasets
• Stable sort algorithms preserve row relationships
• In-memory vs disk-based sorting based on data size

Incremental Loading

• Load data in chunks rather than all at once
• Set appropriate page sizes based on your hardware
• Use streaming for real-time data feeds

Column Selection

• Load only necessary columns to reduce memory usage
• Hide unused columns to improve rendering performance
• Consider data types - text columns use more memory than numbers

Batch Operations

• Group similar operations together
• Use bulk edit features instead of row-by-row changes
• Apply filters before expensive transformations

PXL Expression Performance

• Simple expressions execute faster than complex ones
• Cache results of expensive calculations
• Use column references instead of rebuilding data

• Render Time: How long it takes to display data
• Memory Usage: Current browser memory consumption
• Query Duration: Time for filters and sorts to complete
• Cache Hit Rate: Efficiency of data caching

The system provides automatic recommendations:

• Suggest column hiding for unused data
• Recommend filter order changes
• Identify slow-performing expressions
• Memory cleanup suggestions for long sessions