well, for >10k rows most likely it is better to use more specialized tools to create pivot tables. Google Sheets as browser app just not intended to do this.