7 ms·
I also had misfortune working with MSSQL is it was so so unbearably slow, because i couldnt upload data in bulk. I guess its forbidden technology
by dgan 1y ago
I also had misfortune working with MSSQL is it was so so unbearably slow, because i couldnt upload data in bulk. I guess its forbidden technology
- Foobar8568 1y agoOr you didn't use MSSQL properly, there are at least 2 or 3 ways to do bulk upload on MS SQL, not sure in today era.
- dgan 1y agoMaybe? Don't know. I never had problemes bulk uploading into Postgres tho, it's right there in documentation and I don't have to have a weird executable on my corporately castrated laptop
- Foobar8568 1y agohttps://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver17 https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-... That's one way, another was BCP. But yeah if you are using python and loading row by row, or a large amount into a large table that has a clustered index, chances are that it'll be dead slow but that's expected.
- dgan 1y agoThe documentation you providee requires for the file to be present on the server side, not the client side, which is very dufferent from postgres. As for BCP executable, i couldnt find a way for it to accept any type of date[time] at all