Adult Content Warning

This community may contain adult content that is not suitable for minors. By closing this dialog box or continuing to navigate this site, you certify that you are 18 years of age and consent to view adult content.

The Tech Help Thread

Discussion in 'Technical Board' started by rei, Oct 19, 2009.

  1. Dcc001

    Dcc001
    Expand Collapse
    New Bitch On Top

    Reputation:
    318
    Joined:
    Oct 19, 2009
    Messages:
    4,011
    Location:
    Sarnia, Ontario
    Since I appear to be on an IT tear this week....

    I love almost everything about this iPhone and curses to Samsung, but Samsung did do one thing easily: emailing attachments. Anyone have any idea how to email attachments (not embed photos) from an iPhone S6 without going through iCloud? Why can't I just select from my photos folder?
     
  2. Trakiel

    Trakiel
    Expand Collapse
    Call me Caitlyn. Got any cake?

    Reputation:
    231
    Joined:
    Nov 3, 2009
    Messages:
    3,096
    Location:
    St. Paul, MN
    I'm currently studying for an auditing certification (CISA) and am using a study guide. Here's a question that appeared on my section quiz:

    True or False?

    I put true and got it right, but really, I don't quite understand the question. I googled what hashing is and kind of understand how it makes lookup searches faster, but don't know what that has to do with indexing or a parallel processing environment. Can someone explain to this in a dumbed down, simple manner?
     
  3. Nettdata

    Nettdata
    Expand Collapse
    Emotionally Jaded

    Reputation:
    1,307
    Joined:
    Feb 14, 2006
    Messages:
    14,120
    https://docs.oracle.com/database/121/VLDBG/GUID-F023D3ED-262F-4B19-950A-D3C8F8CDB4F4.htm#VLDBG1270

    I think that’s pretty well explained. Let me know if you have any questions.
     
  4. Trakiel

    Trakiel
    Expand Collapse
    Call me Caitlyn. Got any cake?

    Reputation:
    231
    Joined:
    Nov 3, 2009
    Messages:
    3,096
    Location:
    St. Paul, MN
  5. Nettdata

    Nettdata
    Expand Collapse
    Emotionally Jaded

    Reputation:
    1,307
    Joined:
    Feb 14, 2006
    Messages:
    14,120
    Exactly.

    When you have data that's packed into the same drive section on the same box, or in the same table/index/partition, etc., you run into resource limitations trying to interact with the data; IO contention, etc.

    If you evenly distribute them across many drives, even across many nodes, you can then run parallel operations against all of the data which spreads that resource usage out, minimizing hot spots (hot spots slow shit down).

    There are technical solutions to that problem, such as crazy expensive storage, etc, but simple hashing like that is a fairly simple potential performance improvement.

    It's also pretty effective at evenly distributing load across a cluster, so you don't have a single node that is crazy busy because it's got, for example, all of this month's data in it. If you spread that data out, you can better take advantage of the entire cluster's computing power.
     
    #1465 Nettdata, Sep 24, 2017
    Last edited: Sep 24, 2017
  6. $100T2

    $100T2
    Expand Collapse
    Emotionally Jaded

    Reputation:
    65
    Joined:
    Oct 19, 2009
    Messages:
    1,884
    Thinking of trying a Raspberry Pi kit. Has anyone done one, and which would you all recommend?
     
  7. Zach

    Zach
    Expand Collapse
    Experienced Idiot

    Reputation:
    30
    Joined:
    Oct 19, 2009
    Messages:
    167
  8. Nettdata

    Nettdata
    Expand Collapse
    Emotionally Jaded

    Reputation:
    1,307
    Joined:
    Feb 14, 2006
    Messages:
    14,120
    Same... I have 3 of them... one of them running a media client in the shop, and 2 others as a driver for "network/application status" monitors.

    I got the complete kit with the wifi dongle, case, and large memory cards... especially for the media box (where anything below 32GB is almost unusable, and 64GB works pretty well).
     
  9. Nettdata

    Nettdata
    Expand Collapse
    Emotionally Jaded

    Reputation:
    1,307
    Joined:
    Feb 14, 2006
    Messages:
    14,120
  10. Frebis

    Frebis
    Expand Collapse
    Emotionally Jaded

    Reputation:
    233
    Joined:
    Oct 19, 2009
    Messages:
    1,961
    I used to build emulator boxes and sell them. It will play anything PS1 and before ( plus some N64).

    What do you want to do with it? They work really well for KODI setups. I’ve also used them to host LAMP setups to run local web pages. I wish they could run the MEAN stack. But Node doesn’t run well.

    I think I’m going to make my wife a magic mirror for Christmas with one.

    I also read a tutorial for how to integrate one into an old Furby with Alexa.

    It is my favorite computing thing.

    But it all depends on what you want to do with it.
     
  11. Juice

    Juice
    Expand Collapse
    Moderately Gender Fluid

    Reputation:
    665
    Joined:
    Oct 19, 2009
    Messages:
    7,357
    Location:
    Boston
    I have two Raspberry Pis running our domain controller at work.
     
  12. $100T2

    $100T2
    Expand Collapse
    Emotionally Jaded

    Reputation:
    65
    Joined:
    Oct 19, 2009
    Messages:
    1,884
    It's really for my 13 year old son. He is getting interested in computers and looking into the computer science pathway in school, so I thought it would be a good thing to play with.

    Plus, we're looking for something to run MAME, and this seems like a good choice for that.
     
  13. Frebis

    Frebis
    Expand Collapse
    Emotionally Jaded

    Reputation:
    233
    Joined:
    Oct 19, 2009
    Messages:
    1,961
    As long as you are looking to play games published before 95 it works great.

    It’s fun to experiment with but it takes a lot of work. The community is great, but often times when trouble shooting I end up working through ten different tutorials before I find what the first one is missing.

    Pick one up. What’s the worst that happens? You are out $80 for the kit? Or $35 for the pi if you have the other stuff.
     
  14. $100T2

    $100T2
    Expand Collapse
    Emotionally Jaded

    Reputation:
    65
    Joined:
    Oct 19, 2009
    Messages:
    1,884
    Yeah I ordered it for him. I just wanted to get a suggestion from you guys for a good kit. Hopefully he enjoys it and gets into it, and it can be a stepping stone to building bigger and better stuff.
     
  15. ODEN

    ODEN
    Expand Collapse
    Emotionally Jaded

    Reputation:
    116
    Joined:
    Oct 23, 2009
    Messages:
    895
    I am looking at ways to extend my wifi network at home. I currently have a nighthawk AC3200 that covers 95% of the house but I want to get a stronger signal at the far corner of my house and beyond onto my patio. If I were to get an orbi, would that do the trick? Is that even possible?
     
  16. Frebis

    Frebis
    Expand Collapse
    Emotionally Jaded

    Reputation:
    233
    Joined:
    Oct 19, 2009
    Messages:
    1,961
    I would ditch the nighthawk and get an Eero system. That has solved every WiFi issue our house has encountered.
     
  17. Binary

    Binary
    Expand Collapse
    Emotionally Jaded

    Reputation:
    166
    Joined:
    Oct 21, 2009
    Messages:
    2,741
    @ODEN it really depends on whether you'd like to clean up a small issue in a corner of your house, or solve the overall problem of Wi-Fi networks not always reaching where you want them.

    If you want to clean up a small area of your house, a Wi-Fi repeater will work okay. Speeds won't be perfect, but it'll be fine for many/most purposes. Netgear makes a range extender specifically for the Nighthawk series, so you could just use that.

    If you want a more flexible/permanent approach, buying into a mesh system will basically let you extend your Wi-Fi network wherever you want. Frebis has recommended the Eero system, which is a good system. There's also Google Wi-Fi, which is what I have, which trades some flexibility for some simplicity and I have some confidence that Google will continue to support it with software updates. I'm an IT guy by trade and would rather not fiddle when I get home. Netgear's Orbi system is great. Also, Ubiquiti makes a very powerful system.

    You can't mix the two, though. Buying an Orbi will not extend your existing Wi-Fi network.
     
  18. Juice

    Juice
    Expand Collapse
    Moderately Gender Fluid

    Reputation:
    665
    Joined:
    Oct 19, 2009
    Messages:
    7,357
    Location:
    Boston
    @ODEN without reading to much about your router, is beamforming configurable? As in, could it be enabled/disabled? Depending on that, you might get a little more juice out of it.

    Another option, which Im going to do in my new house, is setup 2 access points, which is essentially what Eero is anyway (kind of). Im going to do it the old fashioned way and run CAT6 cable, but I would rather do that than mess around with extenders. You definitely have options on how to approach it.
     
  19. Nettdata

    Nettdata
    Expand Collapse
    Emotionally Jaded

    Reputation:
    1,307
    Joined:
    Feb 14, 2006
    Messages:
    14,120
  20. Dcc001

    Dcc001
    Expand Collapse
    New Bitch On Top

    Reputation:
    318
    Joined:
    Oct 19, 2009
    Messages:
    4,011
    Location:
    Sarnia, Ontario
    See the checklist that's shown in this video:



    Anyone know how I make that in Excel? The checklist function help I can find is woefully inadequate and involves making an individual check box that is only loosely linked to a cell and copying it. I want to make the bad boy shown here but I can't find a tutorial.