The Official Status Thread
-
OP_NAME TARGET PCT_DONE TIME_REMAIN SQL_FULLTEXT Table Scan OWNER.BIG_TABLE 19.35% 100.6 min "CREATE INDEX..."
100 minutes remaining
-
well creating indexes does require a full table scan....
hopefully that'll make subsequent queries faster
-
well creating indexes does require a full table scan....
No shit.hopefully that'll make subsequent queries faster
If you create an index which makes them slower, you've done it wrong.Look at the time remaining.
-
No shit.
yeah, that was a bit @captain-ish of me.
If you create an index which makes them slower, you've done it wrong.
well if you have too many of them it can negatively impact updates/inserts significantly
Look at the time remaining.
about an hour fourty.... well it is a big table, no?
-
you can do it i'm sure. we must prove that math.js syntax is turing complete!
I think I've got it figured out now. Will try tomorrow when I am back at a proper keyboard.
-
I swear I've had cases where it's quicker to
CREATE INDEX
,SELECT things
andDROP INDEX
than justSELECT things
. Never quite understood that
-
well if you have too many of them it can negatively impact updates/inserts significantly
True, but those aren't queries.
about an hour fourty.... well it is a big table, no?
Plus the time it's been running. I ain't got time for this shitI've also just realised it's index 2 of 4 that need creating on the same table.
-
why drop the index if it helps?
and yeah that would help if you're going to need to do multiple table scans using that index? the index does one table scan at O(N) and then the joins use the index at O(logN) where they'd all be O(N) without the index.
-
Unless you're silly with your query then it ignores the index anyway.
-
well, yes. given that @jaloopa says the index improves speed i'm assuming that he isn't being silly with the query.
-
if the data changes, and the index is implemented with a B+ tree, there's a posibility that the tree will become unbalanced, and regenerating the index is the only way to get it right.
maybe, i should re read the theory on that.
-
why drop the index if it helps?
I don't remember now, but I'm sure it made sense at the time.
Possibly the table normally had a lot more inserts than selects, so keeping the index there would have slowed it down. Possibly there was no need to drop it but I did anyway
-
A single index won't appreciably slow down inserts, especially if it's just one
int
column that's indexed ;)
-
never asume that a DB schema is sane, never
-
never asume that a DB schema is sane, never
I draw the honourable gentleman's attention to:
http://what.thedailywtf.com/t/from-a-single-insert-statement/8230
-
Status the second:
AddedPARALLEL (DEGREE 4)
and re-ran it - finished the initial scan in less than a minute
-
It's great when it does the shortcuts on mobile even though the text editor window is open. One of my favorite bugs.
-
I wasn't planning to sleep tonight anyway
-
How the fuck?!
-
How do keyboard shortcuts even work on a platform without a physical keyboard?
-
Listen, there's so many goddamned bugs on Windows Phone 8.1 that there's no point even trying to enumerate them, even if I did care about improving this product. It's more like, "look, dude, just try to use it for five minutes" level of bugginess.
It can't even go more than about 3-4 (virtual) page loads without freezing up and requiring me to hit the "refresh" button.
-
Listen, there's so many goddamned bugs on Windows [...] that there's no point even trying to enumerate them, even if I did care about improving this product
You should try MS DOS.
-
Yeah that's another fucking unfunny idiot April Fools' joke:
https://www.youtube.com/watch?v=irJQDGw8Ptk
Thanks for reminding me, you ass.
-
unfunny idiot April Fools' joke
These guys have it down to a science!
-
It's great when it does the shortcuts on mobile even though the text editor window is open. One of my favorite bugs.
I have not had that particular one happen, it must be specific to Windows phones?
My favorite mobile bug is when I open the browser on my phone, I had last had a Discourse tab open, and then it automatically Infiniscrolls itself to the top of the thread 5-10 posts at a time. It just locks up my phone with no choice but to kill Chrome or wait for it to finish.
Second favorite bug is forgetting to close the browser before I lock my phone and leaving Discourse running in the background and it running my phone dead in less than 2 hours.
-
Second favorite bug is forgetting to close the browser before I lock my phone and leaving Discourse running in the background and it running my phone dead in less than 2 hours.
This one is wonderful on Windows Phones because there is no task killer.
-
This one is wonderful on Windows Phones because there is no task killer.
Hold the Back button: task killer ;)
-
That just brings up open apps for me, doesn't let me kill anything.
Oh, I'm not on 8.1 yet, still 8.0 because US Cellular is stone-age. Don't know if that matters.
-
I'm not on 8.1 yet
Ah. That would be it then.Can you not swipe down on the app to kill it?
-
Nope. The only ways to kill an app are to launch more apps and hope the OS shuts down old ones, or reboot the phone.
-
The only ways to kill an app are to launch more apps and hope the OS shuts down old ones, or reboot the phone.
That seems like an oversight on their part...
-
Status:
Chromium somehow escaped my Virtualbox and is now running rampart on my Windows.
Fuck this shit.
That's it. I'm done. Time to go home and play some games.
-
Status: coffee acquired, music playing, time to do some serious hacking here.
And no, I'm not talking about cobbling together pieces of JavaScript.
-
Chromium somehow escaped my Virtualbox and is now running rampart on my Windows.
How is that even possible?
-
Chromium somehow escaped my Virtualbox and is now running rampart on my Windows.
I've seen that happen a couple of times, never figured out how it managed it.
-
Time to go home and play some games.
Oh right. I'm doing my OS X total immersion thing at home. So no games. Now I can either install Steam and find out which handful of games have Mac versions, or just revert to watching porn. Great.
-
Your "wee-knee"?
I shudder to think about the kind of anatomical defect which would allow one to wee out of the knee...
-
Infini-scroll.... :weeping:
You weren't exaggerating. I can't even use the site anymore. All I want is a list of headlines to see if I'm interested in reading anything, but now I have to page down three times to get all of them. And that social media feed on the right hand side is really distracting.
-
You can log in using OpenID and it'll tell you which of your games run on Linux.
Presumably there's something similar for mac?
-
Button status: Not pressed
-
-
-
Status: the fact that C# generic "where" keywords don't "recurse" is really, really fucking annoying:
CSVValidationResult<CSVValidationError<DocumentCsvRecord>, DocumentCsvRecord>
public class CSVValidationResult<T, U> where T : CSVValidationError<U> where U : CSVRecord<U>
-
I was hesitant to click on that link, but it was worth it.
<was that too obvious?>
-
You weren't exaggerating. I can't even use the site anymore. All I want is a list of headlines to see if I'm interested in reading anything, but now I have to page down three times to get all of them. And that social media feed on the right hand side is really distracting.
It's hard to exaggerate "infnite" ;)
Yes, all those complaints... we haven't heard from @wood lately, I wonder if was a highly-paid consultant on this.
-
well creating indexes does require a full table scan....
From your ellipses, I must conclude that it's a big table. ;-)
-
You weren't exaggerating. I can't even use the site anymore. All I want is a list of headlines to see if I'm interested in reading anything, but now I have to page down three times to get all of them. And that social media feed on the right hand side is really distracting.
They must have hired off some of MSN.com's web devs. The kind of people who see a little speck of white space and decide to jam more content in there. I think sites like that are to blame for the rise in ADD.
-
ah, you are around. i was beginning to wonder. ;-)
-
Status: Moved both my bots and my cyberparts to an EC2 Ubuntu image, because Amazon Linux sucks
-
This is a game that runs on OSX
Well done, you broke the click tracker. Well, I say well done, it's Discourse, can't say I'm too surprised, sorry.