How does pagination affect performance and exports?

If I have a 100k record table on a sheet the dashboard performance is pretty sluggish. Would pagination help with this or would it just worsen performance?

Also if the user wants to export the table to excel, would all 100k records be exported or only the page the user is on?