Heh, that's not so bad - 2 jobs ago I had to fix a KPI generation process that w... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		hobs on Jan 19, 2024 \| parent \| context \| favorite \| on: We migrated our PostgreSQL database with 11 second... Heh, that's not so bad - 2 jobs ago I had to fix a KPI generation process that was 70k lines of dynamic sql, that unwrapped to up to 1m LOC :)

chaz6 on Jan 19, 2024 [–]

Did you ever run into a hard limit of statement size?

hobs on Jan 19, 2024 | [–]

No, but all the code generation was happening in the server itself so I dont know how hard and fast it applies, iirc SQL Server's limits are like 64k x packet size.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact