The 2nd Monitor - 2015-06-14 (page 2 of 3)

« first day (771 days earlier) ← previous day next day → last day (3250 days later) »

Captain Obvious

4:11 PM

0

Q: Experimental binary, decimal, hex calculator in C

In a YouTube video I watched, the speaker said it is important to know how to calculate between numbers of different bases; i.e. two, ten, and sixteen. I was then inspired to write a small C program to ensure I understand how such conversions are done. I then wrote a short Python2 script to test ...

4:26 PM

@EthanBierlein Sweet! Good job!

@Phrancis Thanks! Now the only thing left is to figure out why VS2015 won't let me insert values.

Does inserting values work OK in SSMS?

> Did I miss a walks-into-a-bar-fest?

Monking!

Hey @Mat'sMug!

I'm speechless: codereview.stackexchange.com/a/93538/23788

(2K+ link, deleted answer)

Motoko Kusanagi

4:37 PM

hello

Hi!

Simon André Forsberg

@Mat'sMug hmm... seems to mention some of the same things my answer did

hi Motoko

Motoko Kusanagi

do you people think I made a good title for my question?

Simon André Forsberg

I assume you mean this one?

0

Q: Experimental binary, decimal, hex calculator in C

In a YouTube video I watched, the speaker said it is important to know how to calculate between numbers of different bases; i.e. two, ten, and sixteen. I was then inspired to write a small C program to ensure I understand how such conversions are done. I then wrote a short Python2 script to test ...

Motoko Kusanagi

yes

Simon André Forsberg

4:39 PM

not bad, but not very out of the ordinary either

@SimonAndréForsberg ...look at the links - they're all SO questions. "Broken code is off-topic - is this really always the case?" ..... answerer didn't seem to realize CR != SO.... which is kinda extraordinarily ironic on that question.

Simon André Forsberg

oh, okay

Motoko Kusanagi

maybe something like "fantastically sweet c program that does stuff or breaks if you use it wrong"

jk

actually i'm leaning towards that title now

@MotokoKusanagi The python that ate a calculator

Simon André Forsberg

now we're talking ^^

Motoko Kusanagi

4:44 PM

done

Simon André Forsberg

but wasn't it made in C ?

Motoko Kusanagi

the tags still say c

I think I should have gone with using the strings "AND", "OR", et cetera; instead of the characters bash doesn't like unescaped

but that would break my fancy enum thing

@MotokoKusanagi Do you want the Python part to be reviewed as well?

Motoko Kusanagi

it's not the main focus, but yes

please

@MotokoKusanagi Feel free to add python to your question. If you prefer, I can do it for you.

Motoko Kusanagi

4:52 PM

done

Oh, we burned python2 and turned it into Python I see...

user image

Oh, you found the specific one.

Good :-)

@EthanBierlein I saw 200's answer and tested for injection and AFAIK, it's not vulnerable

Tried multiple ways, not just the one above

Simon André Forsberg

@Phrancis trying to SQL inject SEDE?

4:54 PM

I think the comma after the variable in LIKE CONCAT('%', @QuestionTags, '%'); is what is helping you

Simon André Forsberg

I don't think SEDE is vulnerable to SQL injections

^ That could also very well be the case. Now I'm curious...

user image

@SimonAndréForsberg I have successfully SQL-injected SEDE (with something completely benign)

I wonder if I should report this vulnerability...

Simon André Forsberg

@Phrancis I think that part might be by design

Could be... @rolfl what do you think? ^^

Captain Obvious

0

Q: Laravel 4 search function

I am using the below code in my controller, I would like to know if this is good code to use or if I can write it better, or more compact, and so on. I am just trying to learn from this. The below code does work, so that is not my question :) public function search() { $search = Input::g...

0

Q: MySQL: OR vs UNION

I have a dilemma. I have a messages table containing fields id, sender, receiver, body I need to select all users a given user has had a conversation with. A conversation may be a single message without a response. Here's a show create table for you to see the indexes (as I may have set them up ...

5:03 PM

@Phrancis SEDE is an SQL injection

I mean, anyone, by design, is invited to enter SQL in to a text box, which is run against a database.

Simon André Forsberg

that ^^

The whole thing is managed using the SQL permissions.

you have read-only access to the data, and you can manage your own personal space in the tempdb.

Simon André Forsberg

Why do the SQL injection in an input text field when you can just change the original SQL directly?

I mean, have you seen this query? data.stackexchange.com/stackoverflow/query/199310/… <--- it is an SQL injection with other insert injections added in to tables created, and then those inserts are "eval" executed, followed by another nested "eval" to select the data. An Inception query, injections in injections, in injections.

4

@rolfl I know it's harmless in this case, but if anyone ever stated something like that about a production server...

I'd shiver.

5:12 PM

Well, get shivering ;-)

On the other hand, the database is isolated from the live system.

@rolfl Whoa.

if someone were to actually break things, the impact would be limited to an isolated system, which could simply be deactivated, and rebuilt, if needed.

@CaptainObvious That was easy enough.

You'd think people would check the exec plan before even posting to ask which is the more efficient query. Oh well.

@CaptainObvious why did noone tag this php?

@rolfl @SimonAndréForsberg Thanks for clarifying, just wanted to make sure :)

Motoko Kusanagi

5:19 PM

now that I've noticed a bug in my c code, i'm wondering how many changes it will take to make it work after changing the result printout from unsigned long to long int :(

@rolfl Re-imported I suppose? There's not much to built if it's just a copy made every once in a while.

@MotokoKusanagi If you can make it work before the first answer or enough close votes hit, there is no problem.

The moment an answer hits, you won't be allowed to change your code.

Motoko Kusanagi

maybe i'll just append with a diff

it doesn't fail the simple unit test

phew

@MotokoKusanagi Don't sweat too hard, it's a good question.

Motoko Kusanagi

@Mast thanks

SE sites can be so different from each other. There was some fun about CR and PCG earlier today, but every site has it's own flow and it's own standards.

Somebody should get his PhD about SE.

Motoko Kusanagi

5:32 PM

"Can read other people's code" is a good interview statement

that's something i'm still working on

cool title. and nice code mate!

Captain Obvious

5:49 PM

0

Q: My $.each loop is quite slow. Any methods of making it faster?

I have a chrome extension that needs to look through every <p></p> on a webpage. My chrome extension looks at the p text and checks if the text is located in an array. The problem is, the array has over 3,000 elements and I'd quite like to get that up to 12,000 or more if possible. At the curren...

javascript jquery

@MotokoKusanagi And this will certainly by my highest selling at the moment, with no actual job experience.

Dear (rest of the USA) I've been using the Metric system for 10 years now. It's nice, you should try it, divisible by 10 is easier!

Tweeted by tinkertim on June 14, 2015 at 5:48 PM

IKR^

@Phrancis I think that NVARCHAR input in general shouldn't have to be surrounded by quotes. ''

But it has to, it's just like a string literal in any other programming language

No, what I'm saying is that on the SEDE, users of a query shouldn't have to put quotes around text in the input field.

5:58 PM

console.log("hello, world"); vs. console.log(hello world);

Oh, OK

Sorry, I misunderstood :)

That's okay.

Now back to TSQL after heavy yard work.

I'm checking One Vote Short again, and I still have a one-away. This list has reached over 200 posts, too. Surely someone has many votes to spare for it.

I think the reason behind that is that the string is directly inserted into the query, just as if you wrote it into the SQL code. Some programs like SSRS will have a more user-friendly search where it fills in the missing characters (like quote marks around strings, or commas in a list of newline-separated values)

@Jamal Looks like we just got a fresh data dump too, I'll see if I can help make a dent in it :)

Would it be more useful to prioritize older or newer posts? Or prioritize by specific badge?

Or perhaps prioritize users with less rep?

Greetings

I usually just go by my favorite tags, then look at everything else if I still have votes. I don't otherwise prioritize any posts by badge or user.

6:07 PM

What do you think about the idea of a code to convert PHP syntax into Javascript?

What would be a use case for that?

@Phrancis Not having to look at PHP.

3

LOL

And running the PHP code on your browser

I think it would be probably far more complex than you might think at first

6:08 PM

It seems pretty simple

Yes, the array() would be a nightmare

And heredocs too

And nowdocs

And what about all the server-side stuff PHP can do that JavaScript can't, and vice-versa for client-side stuff

And strings with heredocs and nowdocs and with whatnot

I said syntax, not the API

Ah

phpjs.org

For the API, you have that

I see. Looks like a dead project though, last update was over 2 years ago

But, syntax-wise, is JS really that much better than PHP? It's a little better, sure.

6:12 PM

Syntax-wise, PHP and Javascript are really close

But, one way or the other, I still don't really see a use case

Just for the run

*fun

I'm sure that some people would think it is preposterous to run PHP on Javascript

I guess it'd be a more constructive thing to do "just for fun" than doing FizzBuzz

PHPFiddle probably runs on JavaScript

(at least for the client side stuff)

It runs server-side

I have no idea what FizzBuzz is

5

And I read it everywhere

You're probably better off that way ;)

It's a simple exercise in using modulus operations and getting conditions in the right order.

6:19 PM

I tried it once, and I somewhat made it to work as expected

But I still don't get it.

for (i = 1; i <= 100; i++) {
  if (i % (3 x 5) === 0) { console.log("FizzBuzz") }
  else if (i % 3 === 0) { console.log("Fizz") }
  else if (i % 5 === 0) { console.log("Buzz") }
  else { console.log(i) }
}

FizzBuzz in JavaScript ^^

Thank

Now I get it!

Ugly JS, but JS nonetheless ;)

Captain Obvious

0

Q: Populating Charts with Chart.js

I have a dashboard page which populates some charts. They execute a Linq query to then transform the data into Json to populate the Chart. These charts maybe used throughout the site, so I am looking to make them as reuse-able as possible. Something just doesn't feel quite right with the way I ...

c# linq asp.net-mvc

Well, could be worst

For that to be valid C, you need to add a line with #define console.log( printf("%s",?

6:35 PM

YAY I THINK I GOT IT WORKING

@EthanBierlein What's "it"?

@IsmaelMiguel TSQL with VS2015.

Oh

And I have a large database of planets to work with as well, so it's not boring!

Of course, the express edition limits you to 1000 rows :(

Is there any planet made entirely of diamond?

6:38 PM

@IsmaelMiguel space.com/18011-super-earth-planet-diamond-world.html

Or is it making in implicit LIMIT 0,1000?

No, the express edition physically limits you to 1000 rows. It'll throw an error if you have more than that.

I've read somewhere that there's a moon with oil

My instincts says "BULLSH*T"

Am I wrong?

Well, oil comes from the crushed remains of dead creatures.

So unless the moon had life, then yes, I agree with "BULLSH*T"

brb, gonna go get lunch

Jeroen Vannevel

@EthanBierlein lol wat

Just because a query automatically adds "limit 1000" doesn't make that a hard limitation

I take it you generate a select query using the context menu?

6:46 PM

@EthanBierlein It could have some other hidro-carbonet (bad translation is bad) or something similar

@EthanBierlein meh.. that's not really correct..

since it's not actually "crushed remains of dead creatures", but "heated and pressurized carbon-hydrogen compounds"

@Vogel612 Well, sure.

needing life for oil is a fallacy ;)

@JeroenVannevel No, I actually downloaded part of an exoplanet database as a csv, ran that csv through a small python script (for converting characters/integers and such), and copy-pasted it into a .sql file.

It's an inefficient method to be sure, but at least it works.

codereview.stackexchange.com — Paul Collingwood 1 min ago

Perhaps you should check out codereview.stackexchange.com ? — Mureinik 1 min ago

7:02 PM

@EthanBierlein Have you considered downloading the AdventureWorks2012 database? Microsoft made it specifically to help people practice with TSQL

@Phrancis Nope. I haven't checked it out, but it certainly looks interesting. Thanks! :)

@EthanBierlein Have I shown you before how to easily go from Excel/CSV to SQL query? It's a simple matter of writing an Excel formula to include the data in the cells wrapped by SQL code

Hmm, no. I haven't heard of that. Is there a tut. online somewhere?

user image

Look at the formula field

Then all you have to do is copy the contents of column B, and paste into your SQL engine's query editor

(replacing the last comma with a semicolon)

Captain Obvious

0

Q: Safe stack operations with lens

I wrote this code to learn how to work with State monad. Then I added Either result to gracefully handle error condition (stack underflow). I believe most of this code is actually unnecessary. I know there are stateful and monadic lens out there, there is EitherT transformer and also StateStack ...

7:11 PM

@CaptainObvious More Haskell magic

main = do
    print $ runState (push "Hello" >> pop >> pop >>= safely (++" World!") >> pop) []
    print $ runState (push 2 >> pop >>= safely (**7) >> pop) []

I didn't know Haskell could work directly on stacks, interesting. Very close-to-the-metal.

Captain Obvious

0

Q: Stopping all Runnable tasks when one is terminated

I want to run couple of Runnables. If one is failed, all others'execution should be terminated.Here is my approach. I got idea on this from this question and this article . In my code, I check the first runnable which completes its task and evaluated. If that checking is failed ( completionS...

0

Q: // , How do I create a FAQ or Help page?

// , An easy way to test certain theories about improving codereview's demographics would be to run ads on StackOverflow. I ask because I would like to form an opinion for myself about how hard it is to add FAQs. A specific answer to this question will allow me this. A "where should I ask?" F...

discussion support

Captain Obvious

0

Q: PHP Autoload Class From Namespace

I wrote this function to be passed as a param in spl_autoload_register(). It autoloads PHP classes from their respective directories using their namespace, named the same as path. I am not sure if there would be any easier way but this is quite simple and does what it needs to. spl_autoload_regi...

7:28 PM

"use strict";
const THREE = 3;
const FIVE = 5;

for (var i = 1; i <= 100; i++) {
    if (i % (THREE * FIVE) === 0) {
      console.log("FizzBuzz");
    }
    else if (i % THREE === 0) {
      console.log("Fizz");
    }
    else if (i % FIVE === 0) {
      console.log("Buzz");
    }
    else {
      console.log(i);
    }
}

@IsmaelMiguel FizzBuzz in JS, refactored and all ;)

goddamn!

You really liked FizzBuzz

Nah, mostly just bored at the moment

repl.it/s1K

7

A: June 2015 Community Challenge

Decrypt a monoalphabetic substitution cipher A monoalphabetic substitution cipher applies a substitution table to the letters in the plaintext (often omitting all non-letters to disguise the word boundaries). For example, if the table is: plaintext ABCDEFGHIJKLMNOPQRSTUVWXYZ ciphertext RDYBX...

Decrypt a what???

Still, you really went above and beyound with FizzBuzz

7:35 PM

@IsmaelMiguel You have no idea... ;-)

@rolfl That would be tremendously easy to brute-force with SQL, I'm guessing there's probably a "smart" way to do it though?

An algorithm of some kind, or whatever

@Gareth put together a question here:

6

Q: Decrypting a substitution cipher using n-gram frequency analysis

This is a solution for the June 2015 Community Challenge: a program that decrypts a monoalphabetic substitution cipher. It's written in Python 3, but should be portable to Python 2 if you use from __future__ import division. Please review! Is the technique clear and the code easy to follow? Does...

python cryptography community-challenge

It uses ngrams, which are a relatively well understood mechanism for analyzing patterns in "real" text, and then searching for matching patterns in other text allows you to do a statistical fitting of the results.

Watson (IBM's watson) uses that technique a lot.

Ahhh OK, that looks very interesting

There are some ~~algorithmic~~ language problems in his approach, but the statistics wash it out OK.

Hmm, the main problem (in my mind) would be where to put the spaces and other non-letter characters

Well, that's my concern as well.

his code strips all punctuation (and space) from the base data (the corpus).

So, for example, it would be soforexample

this matches how the cipher works.

7:43 PM

Which is still readable, but not ideal

but, I would be tempted to replace punctuation with spaces, and then try to fit spaces in to the solution.

word ends/beginnings are critical information, and it is completely lost in his approach, and it thus pollutes the ngram frequencies a lot.

I'd be tempted to brute-force by having a massive dataset with every ASCII code along with a random but distinct replacement for it, but that's probably also why I don't work in cryptography.

for example, the word "the" has a high frequency, and is a distinct word. In the context of his problem, I would prefer the ngrams " th" "the" and "he "

You sound like you should be writing an answer to it

Wow

7:48 PM

Without the spaces, the frequency of the "he " ngram is polluted by whatever word comes after, for example, "the car" would be the ngram "hec" instead of "he ".

Sorry the delay

I'm killing BAMs

The problem though, is that you have to then inject spaces back in to the cryptographic text, and you don't know where the spaces should go.

I would be tempted to inject them in a way that tries the various combinations, and finds the combination that then matches the best ngram scores.

Monknoon

@EthanBierlein ?

@EthanBierlein Blasphemy!

8:03 PM

Know your memes:

21

A: What's a Zombie? And what are the many other memes of Code Review?

Meme: Monking Originator: Morwenn Cultural Height: The 2nd Monitor Background: A morning greeting to the Monkey doing his monkey-business, in other words: monking Examples: A small chat search Variations: Monkernoon, Monkevening, Monknight, ... Important is only that it begins with Monk... ;...

So I'm guessing a 1-to-1 replacement of the original character with the crypt character, including spaces and all, would be a bad idea?

Or at least, not really address what the original community-challenge is about...

Ugh, code dump answer

6

A: Codility Frog Jump - Count minimal number of jumps from position X to Y

Maybe you should try something like: public class Frog { public static int solution(int x, int y, int d) { return (int) Math.ceil((y - x) / (float)d); }

@janos Am I remembering correct you're interested in those?

sounds more like codereview, tried that site? — CyberSpock 50 secs ago

Ah, when I said ASCII, what I really wanted to say was Unicode

So I would replace, say, U+0020 (space) with another random but distinct Unicode character

But I think it would get dicey if the encrypted string of characters contained a space (as the random "encrypted" character) if it was used for, say, a URL or something.

@Mast "interested" is a strong word...

8:13 PM

Funny how a problem that seems simple on the surface, turns out to become hugely complicated when you start digging.

@Phrancis Solution: don't dig, just write.

Motoko Kusanagi

I just received the best. answer. ever

Pimp it?

I have to admit, it is better than mine

@MotokoKusanagi Veedrac, I've seen him before. Writes decent answers indeed.

8:24 PM

Seen him too.

Talking of pimping...

It used to be that the core Code Review community was to be found hanging out in chat.

could use an answer, eh?

@rolfl luckily that changed

I have found in the past year or so that the balance has moved back to the main site.

@rolfl I don't know - we are all just in VBA Rubberducking now.

what's the main site?

8:26 PM

there are a number of submarine answerers out there - work in stealth, surface to fire high-yield answers, and then submerge again for the next round.

3

@janos as opposed to chat.

@rolfl Actually we got quite a lot of those.

It did not used to be the case.

Motoko Kusanagi

software ninjaneers?

2

flambino is the sub-answerer that comes to mind most often.

20.6k 1 17 57

javascript ruby jquery ruby-on-rails beginner html coffeescript

just keeps on ticking.

Flambino, Gareth (although he does show up in chat every once now and then), Edward, we got a couple

8:28 PM

true, many good answerers I almost never (or really never) see here

others like jonsharpe, gareth, JS1, etc.

Loki.

@janos When I started in this chat, you weren't here either. What changed?

Tim, glampert, ...

I don't come here a lot

the list goes on, and it's larger than the chat-crowd.

All of those. Very good.

8:29 PM

sometimes it's also a matter of timezone

at around UTC 6, mjolka and heslascher are sometimes around

Motoko I've seen regularly in the review queues.

@janos They're in chat often, so they don't count in this particular instance.

palacsint still hits the review queues regularly, but seldom answers.

^^^ that seems like a really selfless thing to do

Indeed: codereview.stackexchange.com/users/7076/palacsint?tab=activity

Captain Obvious

8:32 PM

3

Q: Removing parameters refactoring

After the Reorder Parameters refactoring, I implemented a Remove Parameters refactoring (no, it didn't take this long, just been busy). Also, we completely refactored all the refactorings and implemented a couple interfaces for them all, which you can find here; for reference, the Remove refacto...

0

Q: Thread program that calculates pi

Writing a program for class that calculates pi. Got all the coding done and program runs - but for certain values it doesn't work. The program is supposed to take in 2 parameters, the 1st one is the number of elements to calculate pi and the second is the number of threads to use. It works flawle...

c linux pthreads unix

@Mast you see, I'd never know, cause we come in very different timezones

@janos We're both from Europe ^^

ok, time ranges then (I'm also from Europe)

Hit 8k.

@Hosch250 Congratz!

8:35 PM

nice going!

60 more, and I re-pass someone up.

A couple hundred until the first page.

@rolfl Don't forget cimmanon (great for those who suffer from dyslexia)

Yup. Loki does too.

@Hosch250 He has great answers.

He sure does.

The best part is, I have an accept from him.

8:38 PM

wow. the guys preventing you from the first page are jonrsharpe and maaartinus

I was ahead of Jon for a while.

I wonder if anyone's ever asked why there are three "a" in maaartinus

@janos Ah, another one we forgot to mention, maaartinus

This brings me to ask the very biased question: "How does one keep up with CR without chat?"

I should write an answer and pass maaartinus.

8:41 PM

@Phrancis There are more ways to receive feeds.

I see a lot of good guys on page 2

page 3 as well

Pimp...

that's nice @Phrancis

too bad way beyond cap today

Deservedly

Ah

140 "lost"

8:46 PM

I'm surprised there are that many users active right now, unusual for weekends

At least, from my experience

actually Sunday I find evenings usually pretty good

I should have known and answered less

I also think the one-vote-short query got a lot of attention today....

that helps for Sunday rep bumps.... if you have a post on the list.

I noticed. Not the best timing for me, but then again, that kind of thing tends to happen this time of the week....

actually on Sunday nights somehow I especially like to spend all my votes

Well, yeah, as it happens I hit DVLR ... though I think some downvotes may have been returned....

nope.

last week my weekly vote score was 85 on Monday evening :) (instead of the supposed maximum of 80) That was kinda funny

8:58 PM

down-voted deleted posts have the otes returned, but not un-couinted..... makes for some interesting numbers.

I presume you guys are familiar with multi-threading?

I have to run.,

            lock (midi_output)
            {
                if (!midi_output.disposed)
                    midi_output.Send(MidiMessage.StartNote(number, volume, channel).RawData);

                Timer t = new Timer(_ =>
                {
                    lock (midi_output)
                    {
                        if(!midi_output.disposed)
                            midi_output.Send(MidiMessage.StopNote(number, 0, channel).RawData);
                    }
                },
                null, duration, Timeout.Infinite);

That does NOT look right.

Look at the nested locks...

Before I go ( @janos - perhaps you're interested? ) bounty now on:

13

Q: Mapping arbitrary Int values to a linear index space

This is part of a growing "primitive" tools collection here on github, and is the initial use-case for the IntArray for review here. Often, when processing data, you encounter unique values that you need to use as keys in a lookup system. These keys could be anything from IP addresses, times, id...

java performance array hash-table

hm, juicy!

I saw it high up in the unanswered list, and was gonna make a pass anyway. Now you made it absolutely irresistible

not today though

9:02 PM

@rolfl that's one of these questions that shows me again and again how little I know about java..

@Hosch250 midi... Are you dealing with music/audio stuff?

Yes.

Well, I'm not.

I'm writing a review.

OK. I know quite a bit about MIDI, in case you have questions.

Nope, just about the multi-threading.

I think I solved it.

Cool!

Underloved

9:05 PM

Just got an accept from @rolfl.

Captain Obvious

0

Q: Rule of 5 - C++11

Source/Context: What is the copy-and-swap idiom? Rule-of-Three becomes Rule-of-Five with C++11? The C++ Programming Language 4th Edition June 2013 - Section 17.1 Introduction 483 class X { X(Sometype); // ‘‘ordinar y constructor’’: create an object X(); // default constructor X(const X&

c++11 constructor

0

Q: Hackerrank's Sherlock and Array

Challenge can be found here Problem Statement Watson gives Sherlock an array A of length N. Then he asks him to determine if there exists an element in the array such that the sum of the elements on its left is equal to the sum of the elements on its right. If there are no elements...

java performance algorithm search

@CaptainObvious broken.

0

A: A Note class which plays a note and stops it after specific period of time

Braces: Braces are always good to have, although they are not always necessary. In your original code, this if is quite difficult to read: if(!disposed) t = new Timer(_ => { lock(midi_output) { midi_output.Send(MidiMessage.StopNote(number, 0...

Going on a bike ride, BBL.

If that is wrong, just DV, and I'll remove it when I get back.

the snippets in this question are absolutely pointless, right?

I'm seriously debating with myself as to whether or not I feel like firing off MySQL to get evidence that one of my answers is right... ugh.

9:15 PM

forgot the link, [this question](http://codereview.stackexchange.com/questions/92732/basic-registration-page-and-database-insertion)
^^^ completely pointless snippets there, right?

I noticed this myself too but what made me ask this question is that I asked myself how this all works. Yes the union creates a derived table but I know that only one index can be used in a single where clause thus the simple query will only benefit from either of the indexes, and to fulfill the query will have to do an all scan for the other parameter. With a lot of records this will be way slower than the complex query. — php_nub_qq 4 hours ago

I found no evidence that it's actually the case "that only one index can be used in a single where clause", do you have a link? I read this page about MySQL optimizations but it did not seem to mention this, unless I read it wrong? — Phrancis 4 hours ago

crap.-.

fuu... sorry I missed the "timeout" in the issues statement, my bad. Are all other test-cases going through cleanly? — Vogel612 24 secs ago

@janos yes, they are.

thanks!

ttgtb, catch you later

@janos 'night!

@Hosch250 not quite sure whether they are truly nested... does Timer fire up a separate thread?

9:21 PM

How much data is enough data where UNION would be better than using OR in a WHERE clause. Thousands of records? Millions? Billions?

@Phrancis why not ask in the Heap?

Now that is a great idea!

May I ask something stupid?

sure... maybe you won't get an answer though.

Why in the living hell everybody abbreviates everything?

Aren't we supposed to send a CLEAR message when communicating?

9:30 PM

ehhhm... that question is definitely not stupid..

the answer might be..

but then again I don't know the answer.

Less bytes!

AFAIK, abbreviations are nice for convenience, as long as everybody involved knows what they mean

But this isn't codegolfing

@Phrancis The problem is that some make no sense

Laughing Out Loud

LOL used to mean "Lots of Love"

As far as I know

9:32 PM

Well, you asked a very general question, you got a very general answer

If you have a question about a specific abbreviation, then it would help get you a specific answer

I know it was general

But, as you can see, not every abbreviation means what we think

True, but most of them do, at least within circles

Exactly

But, even within circles, some make no sense

If I told my wife I'm working on a "SQL query" she would be like "WTF is that?", but if I told you, you'd say "OK cool" (or something like that)

But yeah, agreed. Some abbreviations are just cryptic.

lol

is this question broken code?

I saw it in the Close Votes queue

9:38 PM

@Phrancis Actually, I would ask if you need help

:)

@Quill There's nothing stating (clearly) that the code is broken

@IsmaelMiguel I'd hope it wouldn't get a close vote for nothing, if that's the case

wow, I actually thought Test, but apparently not

-3

Q: What's The Code For Show Detail Devices

Whats the code used for Show Device Name And iOS version , see this image down below And Thanx For Help Me.. http://i.stack.imgur.com/gbsef.png And i'm created this page but i want create this item marked on the picture , please learn me how to thank all members

javascript php html

@Quill Well, I don't see anything clearly stating that the code isn't running as expected

« first day (771 days earlier) ← previous day next day → last day (3250 days later) »

Transcript for

Jun '1514

The 2nd Monitor

General discussion about codereview.stackexchange.com - Welcom...

addicted-to-cr here-be-pedants just-saying-hi monkey-business my-code-is-compiling nice-people-room

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile