|
like SQL people weren't like oh this is cool, lets throw it in here as a cool feature. they're integral to good database design.
|
# ? Jul 25, 2014 23:05 |
|
|
# ? May 27, 2024 02:34 |
|
Squinty Applebottom posted:you need info for resourceid = 509 out of 1 billion well either way you have to do an index lookup. with a clustered index now you have your data. with a regular index you have to do up to one more seek to get the row from the block cache. it will help if you do a super ridiculous amount of primary key lookups and have a low hit rate on the block cache. this isn't something i've ever run into, that's all
|
# ? Jul 25, 2014 23:16 |
|
Kevin Mitnick P.E. posted:dunno man i just put jackson on the classpath, annotate the controller class with @RestController, and return pojos from my controller methods I wasn't doing MVC. I was trying to work with a old .NET 2.0 forms thing. Sr Dev doesn't do MVC and nobody else there does either. Then again right now he's the ONLY other programmer. By the way, I've read the documentation, and stack overflow, and none of it worked. I built, rebuilt, cleaned, checked assemblies, restarted VS, restarted my machine, did all the voodoo I can think of, and welp nope. I busted out fiddler, went through the motions, kept seeing my poo poo wrapped up in xml. POST, GET, content type, all that poo poo. No CSV though, lol. I'm just going to do it in loving MVC, because I've done this in MVC before. Goddamn. I did this exact loving thing all day thoughtlessly. I know there's SOME config thing somewhere, and I was wondering if anyone else had ran into this, but I guess everyone would rather just assume "pee pee doo doo lazy/bad/lazybad programmer" because we're all bitter loving goons. raruler posted:and a reminder to be constantly vigilant in the face of SQL joins w-wat about hash j-joins?? is there weed
|
# ? Jul 25, 2014 23:16 |
|
all my indexes are clustered and highly available
|
# ? Jul 25, 2014 23:16 |
|
Shaggar posted:all my indexes are clustered and highly available that's what your mom said last night, my seeks executed in O(2n) but I only paid for O(n)
|
# ? Jul 25, 2014 23:21 |
|
gently caress them posted:I wasn't doing MVC. what i'm suggesting is to step through ASP.NET with a debugger as it builds the response. or does MS not let you see the source lol
|
# ? Jul 25, 2014 23:25 |
|
Kevin Mitnick P.E. posted:whats the use case for a clustered index, i've never run into a situation where seeks to fetch rows were a big part of execution time. table scans, big problem They may or may not fix the joins.
|
# ? Jul 25, 2014 23:25 |
|
Kevin Mitnick P.E. posted:what i'm suggesting is to step through ASP.NET with a debugger as it builds the response. or does MS not let you see the source lol Well, that's one of the first things I did. I built up my JSON perfectly. Then it's time to return the string (actually send poo poo down the pipe) and then end the method then end the class then the debugger goes back into my browser. Then jQuery bleats. Then I look in fiddler and WELP IT'S WRAPPED IN XML STRING TAGS. Every single setting I could find to annotate/decorate/throw glitter on the method that actually serializes the thing and poots it out says "ITS JSON" and "ITS GET OR POST WHATEVER YOU SET IT TO LAST" and nope, xml string or xml envelope. I'm just gonna do it fresh in MVC over the weekend or something, to hell with it.
|
# ? Jul 25, 2014 23:28 |
|
gently caress them posted:I guess everyone would rather just assume "pee pee doo doo lazy/bad/lazybad programmer" because we're all bitter loving goons. *is offended when people draw the natural conclusion*
|
# ? Jul 25, 2014 23:30 |
|
Soricidus posted:*posts in thread for terrible programmers* I was assuming it was sarcasm and that this was just the green help thread, not the "come here for abuse when one merely wanted argument" thread.
|
# ? Jul 25, 2014 23:32 |
|
so like return a poco and let asp.net turn it into json
|
# ? Jul 25, 2014 23:33 |
|
Kevin Mitnick P.E. posted:so like return a poco and let asp.net turn it into json Maybe I was asking too insistently and should just let it do it on its own time. Good idea.
|
# ? Jul 25, 2014 23:35 |
|
i'm getting this sense that you're reading posts entirely different from the ones i've written. and also that you're drunk
|
# ? Jul 25, 2014 23:37 |
|
in memory column store get on my level
|
# ? Jul 25, 2014 23:38 |
|
gently caress them posted:I was assuming it was sarcasm and that this was just the green help thread, not the "come here for abuse when one merely wanted argument" thread. If you just fixed the indexes, no one would abuse you
|
# ? Jul 25, 2014 23:44 |
|
I was putting a POCO into a javascriptserializer and I Was in fact sending JSON. I said it was JSON in prior posts. The problem is the stupid server was wrapping it in a single XML string tag set which contained the JSON string. Then with one magic incantation of decorators and web config poo poo it was coming out as SOAP in an xml envelope. I wanted to figure out how to loving stop that instead of capturing it and removing the xml tags in javascript. I mean yeah I could just loving hack it but I'm tired of that. And yeah I'll probably just do it in MVC with a fresh project.
|
# ? Jul 25, 2014 23:44 |
|
coffeetable posted:please compare and contrast your whining bout source control w/ EAT THE EGGS RICOLAs whining bout source control <3
|
# ? Jul 25, 2014 23:44 |
|
isn't gently caress them like 30 years old
|
# ? Jul 26, 2014 00:04 |
|
Blinkz0rz posted:at first i didnt think wpf would be decent at all but i actually like it and c# is really easy to use slowly but surely i've found myself agreeing with shaggar's opinions w/r/t c# and java
|
# ? Jul 26, 2014 00:36 |
|
to be clear though i've yet to ever program in C# or java
|
# ? Jul 26, 2014 00:37 |
|
uncurable mlady posted:that's what your mom said last night, my seeks executed in O(2n) but I only paid for O(n)
|
# ? Jul 26, 2014 00:42 |
|
USSMICHELLEBACHMAN posted:to be clear though i've yet to ever program in C# or java lucky
|
# ? Jul 26, 2014 00:42 |
|
also is your content type application/xml because maybe windows servers are stupid like that?
|
# ? Jul 26, 2014 01:54 |
|
uncurable mlady posted:also is your content type application/xml because maybe windows servers are stupid like that? Nope, I set it to json. Pretty much everywhere I could set it I set it to json explicitly.
|
# ? Jul 26, 2014 02:09 |
|
gently caress if i know then, i dont do weird ms web poo poo
|
# ? Jul 26, 2014 02:31 |
|
why don't you just compile a c++ program as a .cgi and just run that?
|
# ? Jul 26, 2014 03:09 |
|
someone please tell me what i need to change in iterm 2 for osx so that i can jump between whitespace i dont feel like figuring this out right now right now the function key jumps to the start of a line but all the other meta keys dont do anything
|
# ? Jul 26, 2014 03:34 |
|
USSMICHELLEBACHMAN posted:slowly but surely i've found myself agreeing with shaggar's opinions w/r/t c# and java i heard about mybatis from shagger, before that i was loving around with spring's jdbc templates. from then on, i learned that shagger is right
|
# ? Jul 26, 2014 04:03 |
|
just wrote a lil script to scrape the music thread and get all the links. i might mess with the youtube api and see if i can easily add these to a playlist, or is it easy enough to do on the site itself? i don't think i've ever made a playlist on there before.
|
# ? Jul 26, 2014 04:07 |
|
Papes posted:just wrote a lil script to scrape the music thread and get all the links. i might mess with the youtube api and see if i can easily add these to a playlist, or is it easy enough to do on the site itself? i don't think i've ever made a playlist on there before. yeah that'll be real easy. you can probably write a script to do it in the time it would take you to add them all to a list manually. actually i dont know anything about the api but assuming it's like every other api it'll be easy. maybe they dont let you make playlists for some reason who knows.
|
# ? Jul 26, 2014 04:08 |
|
did i miss a funny computar itt someone give me the update
|
# ? Jul 26, 2014 04:14 |
|
also if you are using mysql you can use mysql connector c++
|
# ? Jul 26, 2014 05:05 |
|
USSMICHELLEBACHMAN posted:yeah that'll be real easy. you can probably write a script to do it in the time it would take you to add them all to a list manually. i've found the youtube api to be loving awful in my experience but i've only tried uploading stuff, not other account things
|
# ? Jul 26, 2014 06:18 |
|
opt posted:i heard about mybatis from shagger, before that i was loving around with spring's jdbc templates. from then on, i learned that shagger is right same
|
# ? Jul 26, 2014 08:55 |
|
BONGHITZ posted:why don't you just compile a c++ program as a .cgi and just run that? lol lesson learned, don't try to defuck someone else's decade old poo poo unless you have a drat good reason seriously though every loving DOCUMENTED setting I could find was used and abused and welp gently caress it shaggar was right etc
|
# ? Jul 26, 2014 18:30 |
USSMICHELLEBACHMAN posted:someone please tell me what i need to change in iterm 2 for osx so that i can jump between whitespace i dont feel like figuring this out right now Just use Terminal.app, OP.
|
|
# ? Jul 26, 2014 18:48 |
|
gently caress them posted:lol im not sure if you're being sarcastic but this is a v good lesson to learn it's been around for a decade, working, what the gently caress makes you think you can do better today
|
# ? Jul 26, 2014 18:57 |
|
Dessert Rose posted:im not sure if you're being sarcastic but this is a v good lesson to learn because i wrote tests before i changed a single line because i read the commit log to see how much was API and formatting churn and how much was fixes/features because i deleted it instead of rewriting it
|
# ? Jul 26, 2014 21:19 |
|
Dessert Rose posted:im not sure if you're being sarcastic but this is a v good lesson to learn "Hey add this thing." Ok. [[Spaghetti intensifies]]
|
# ? Jul 26, 2014 21:25 |
|
|
# ? May 27, 2024 02:34 |
|
https://www.youtube.com/playlist?list=PLz4D9vMpmI4I_GwnBUAxP9T-pCPDVL-Ko So I realized that after I ran the script that I wasn't checking for duplicates, I dunno why that just never crossed my mind. There didn't appear to be an easy way to just remove all videos so I just kind of spot checked and removed as many dupes as I could be bothered to. It's me I'm the terrible programmer.
|
# ? Jul 26, 2014 21:51 |