Maintenance operations are optimized to minimize impact:

During Export:

  • Read-only operations (no system impact)
  • Batched queries (smooth processing)
  • Safe to run during business hours

During Delete:

  • Write operations (minor impact)
  • Batched deletions (prevents locks)
  • Recommendation: Run during off-peak hours for large deletes

Best Practices:

  • Schedule large operations (1M+ records) overnight
  • Small operations (< 100K) safe anytime
  • Monitor server load before starting
  • Use batch processing for datasets > 500K records

Performance Safeguards:

  • Automatic memory management
  • Extended timeouts for large operations
  • Transaction-based deletions (rollback on error)

Save this interesting page on your Favorite Social Media