kSPvhmTOlwvMd7Y7E

joined 2 years ago
[–] [email protected] 9 points 8 months ago (1 children)

That sounds interesting, will take a look. I am not against theoretical computer science, i just think Knuth doesn't reads like a good teacher..

[–] [email protected] 5 points 9 months ago (1 children)

I don't understand why this is called a "subset", while clearly containing new syntax

A subset would be understood by older compilers, this is a superset

[–] [email protected] 4 points 9 months ago

Absolutely not a replacement to VBA. Not even close. As usual, Microsoft hypes something everyone wants, and then implements something nobody asked

[–] [email protected] 6 points 9 months ago

I feel offended by you somehow equalizing perl and lisp

[–] [email protected] 22 points 9 months ago

This a much better done meme

The other one before makes zero sense

[–] [email protected] -4 points 10 months ago

2100 parameters is a documented ODBC limitation( which applies on all statements in a batch)

This means that a

"insert into (c1, c2) values (?,?), (?,?)..." can only have 2100 bound parameters, and has nothing to do with code, and even less that surrounding code is "spaghetti"

The tables ARE normalised, the fact that there are 50 colums is because underlying market - data calibration functions expects dozens of parameters, and returns back dozens of other results, such as volatility, implied durations, forward duration and more

The amount of immaturity, inexperience, and ignorance coming from 2 people here is astounding

Blocked

[–] [email protected] 1 points 10 months ago (1 children)

I timed the transaction and opening of the connection, it takes maybe a 100 milliseconds, absolutely doesn't explain ghe abysmal performance

Transaction is needed because 2 tables are touched, i don't want to deal with partially inserted data

Cannot share the code, but it's python calling .NET through "clr", and using SqlBulkCopy

What do you suggest i shouldn't be using that? It's either a prepared query, with thousands of parameters, or a plain text string with parameters inside (which admittedly, i didn't try, might be faster lol)

[–] [email protected] 0 points 10 months ago* (last edited 10 months ago)

Will try bcp & report back EDIT: I can't install bcp because it is only distributed with SQLServer itself, and I cannot install it on my corporate laptop.

[–] [email protected] -1 points 10 months ago* (last edited 10 months ago) (1 children)

I will try bcp. Somehow, i was convinced I had to have access to the machine running the sql server to use it, but from the doca i see i can specify a remote host.. Will report back! EDIT: I can't install bcp because it is only distributed with SQLServer itself, and I cannot install it on my corporate laptop.

[–] [email protected] -2 points 10 months ago (2 children)

Please enlighten us? You barely know anything about the system or usage, and you have deduced nosql is better? Lol

view more: ‹ prev next ›