This is great. One of the sysadmins is pulling some sort of stunt in Powershell. Every minute or so someone's CD drive pops open.
Working, working, working...
*pop*
DAMNIT, MATT
lmao i made someone else mad, I love this new title though, it's much smaller
I want a title.
[sub][sub][sub][sub]and gold[/sub][/sub][/sub][/sub]
[QUOTE=Shadaez;39847079]lmao i made someone else mad, I love this new title though, it's much smaller[/QUOTE]
Source / Why?
[QUOTE=B!N4RY;39846410]rhx123 what GPU did you use for your eGPU btw?
I've been working on one too but I have not picked out a permanent GPU to use yet[/QUOTE]
it kinda said it in the screencap
[QUOTE=Shadaez;39847079]lmao i made someone else mad, I love this new title though, it's much smaller[/QUOTE]
g cuts off :c
[QUOTE=SataniX;39847166]Source / Why?[/QUOTE]
probably tropes v women related, idk though I asked him
[QUOTE=Shadaez;39847240]probably tropes v women related, idk though I asked him[/QUOTE]
Your title made me do something good.
I just removed comic sans from my windoze.
lol someone's mad at shaddy
WHY DID NOBODY TELL ME ABOUT MySQL'S FEDERATED STORAGE ENGINE EARLIER?
Seriously, that basically solves my problems. We've got two databases (well, three, but we're merging them into two) - data and logs. We have to keep them separate, or at least separable, both because at some point they'll need to be separate servers for performance, and because some of the potential customers we're in the running for want to keep data on their local servers, but keep logs in The Cloud.
Reports involve aggregating and collating and fucking synergizing log entries, but those logs need to be connected to data (obviously). Simple example: an access log entry has a person_id, but it needs to display using the person's name.
Problem: How do you "join" tables that exist in different databases?
Solution 1: Run the main query against the logs DB, then do a separate query every time you need to look up a person name or location address or favorite color or whatever. Problem: This results in roughly 25,000 database queries on some reports.
Solution 2: Like 1, but cache the results in memory so you don't make so many queries. Problem: still a shitload of queries
Solution 3: Just slurp the entire table from Data into memory, then line them up yourself. Problem: Out-of-memory.
Solution 4: Run a query against logs DB to find the IDs you'll need ("SELECT DISTINCT" is your friend), then use that to slurp just the entries you need in. Problem: requires a lot of code and possibly runs an expensive query twice.
But you know what?
Solution 5: Create a federated table in logs DB pointing at the data DB table you need, do a join on it. There might even be some tricky things I can do to make it even faster when on the same server (since you can actually do just a cross-DB join with the right user permissions). Problem: SOLVED
Or at least, it will be once I yell at the DB admins a bit, to get them to install the federated storage engine. But hey, that's not my problem, it's theirs.
(PS: Heard a rumor today that the Federal Reserve is switching from Oracle to MySQL for some big database of theirs. Seems relevant to this discussion)
[QUOTE=rhx123;39846601]What adapter are you going to use?
PE4L V2.1b is the best in my opinion at the moment. Due to the weird NVIDIA Compression on the 1x link, there isn't much advantage with using a 2x link even at PCIE 2.0
[editline]8th March 2013[/editline]
It's rather awesome.[/QUOTE]
I'm gonna get this along with a more powerful DC adapter:
[url]http://www.hwtools.net/Adapter/PE4H%20V3.2.html[/url]
[QUOTE=B!N4RY;39847439]I'm gonna get this along with a more powerful DC adapter:
[url]http://www.hwtools.net/Adapter/PE4H%20V3.2.html[/url][/QUOTE]
Which card are you using? Also i remember something about the PE4H not working well with PCIE 2.0.
I will see if I can find it.
[editline]8th March 2013[/editline]
That was the old PE4H, my bad.
I wonder if i could use a HD6670 with one of them.
Apparently it's because I was rude to some guy 3 years ago in sipwicket who lost $200? I have no idea.
[QUOTE=Shadaez;39847755]Apparently it's because I was rude to some guy 3 years ago in sipwicket who lost $200? I have no idea.[/QUOTE]
Wow, way to hold a grudge.
[QUOTE=Shadaez;39847755]Apparently it's because I was rude to some guy 3 years ago in sipwicket who lost $200? I have no idea.[/QUOTE]
Ah, the "hwhchsiz&gc" thread from 3 years ago, apparently
[QUOTE=harryh11;39847862]Ah, the "hwhchsiz&gc" thread from 3 years ago, apparently[/QUOTE]
He's obviously deluded. We weren't at the &GC stage at that point.
i'd change it to something else for you but boostar isn't loading
[QUOTE=Protocol7;39847960]i'd change it to something else for you but boostar isn't loading[/QUOTE]
Working for me.
[QUOTE=spinpoint F3;39847713]I wonder if i could use a HD6670 with one of them.[/QUOTE]
Yes, but you will find it tricky if not impossible to drive the internal lcd with an AMD card, also it will be almost half as fast as an equivalent nv card.
[QUOTE=wingless;39847969]Working for me.[/QUOTE]
[IMG]http://puu.sh/2emDW/f97331bba0[/IMG]
:I
Actually on the thinkpad you've got there would be no difference.
[editline]8th March 2013[/editline]
My merge.
