<transcript><audio_306>transaction is declared committed okay now obviously the scheme at commit time we've optimized a lot of things if this transaction were touching a million objects then it may have just created if it were touching just one bite in the million objects it may have just created</transcript><transcript><audio_307>a few log Pages as opposed to having to write million data pages to this that's why you can see why this is faster but it's still slow because at commit time I still have to wait for that disco to</transcript><transcript><audio_308>come back and those are as you know many tens of milliseconds right uh and so slow and if the now at that comit time</transcript><transcript><audio_309>if the buffer pool Get Zapped out the me Dam Gets Zapped out which means I've lost both buffer pool I can reconstruct from that log file but it's still slow because for each commit I have to wait for the disc to finish now imagine I've got 100 transactions running they all</transcript> transaction is declared committed okay now obviously the scheme at commit time we've optimized a lot of things if this transaction were touching a million objects then it may have just created if it were touching just one bite in the million objects it may have just created a few log Pages as opposed to having to write million data pages to this that's why you can see why this is faster but it's still slow because at commit time I still have to wait for that disco to come back and those are as you know many tens of milliseconds right uh and so slow and if the now at that comit time if the buffer pool Get Zapped out the me Dam Gets Zapped out which means I've lost both buffer pool I can reconstruct from that log file but it's still slow because for each commit I have to wait for the disc to finish now imagine I've got 100 transactions running they all
{"source": "grass-yt-cc-by.-mY8ALcJVTk|shard_1_1|create_multimodal_data.extract_yt_and_generate_transcripts.62|shard_1|create_multimodal_data.generate_captions.62|shard_1|create_multimodal_data.generate_captions.62", "params": {"id": "-mY8ALcJVTk", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 5000, "view_count": 4483, "age_limit": 0, "like_count": 50, "channel_follower_count": 71100, "license": "Creative Commons Attribution license (reuse allowed)", "uploader_id": "@CMUDatabaseGroup", "yt_tar_file": "/leonardo_work/EUHPC_E03_068/audio/fixed_download/grass-yt-cc-by//shard_1/-mY8ALcJVTk.tar.gz"}}