|
The Official PC building thread - 4th Edition
|
|
|
|
AfterDawn Addict
4 product reviews
|
7. February 2014 @ 05:39 |
Link to this message
|
|
Well indeed, for connections under 30Mbps or so, which I understand is a great deal of the USA (and it's still a fair proportion of this country too, I am quite fortunate to receive the service I do here), you can use almost any old router.
What's commonly done to avoid the router slowing down internal network traffic (and indeed, standard practice for any business) is to use a separate switch for internal data, and leave the router out of the equation other than providing internet connectivity to said switch.
|
|
Advertisement
|
|
|
|
Senior Member
|
7. February 2014 @ 06:44 |
Link to this message
|
|
One of the better cable modems allows the following speeds but you are always limited to what your provider is going to give you and they state that in their spec as well.
ARRIS / Motorola SURFboard Gateway SBG6580 DOCSIS 3.0 Wireless N Cable Modem
* Internet download speeds up to 343 Mbps and upload speeds up to 131 Mbps based on your Cable provider service.
So you get 1/3rd Gigabit speeds at best. :D
|
AfterDawn Addict
15 product reviews
|
8. February 2014 @ 01:22 |
Link to this message
|
|
My connection is ~30Mb, in practice around 28-32 depending on time of day. Burst speeds of up to 60Mb at the beginning of a download, meant to make small downloads much quicker. No bottlenecks or issues here with a very basic router.
Also, continuing to fall deeper and deeper in like with my PC :) Lots of OCing experimentation and benchmarking/testing shows some nice improvements. Continues to excel for my needs. Should have upgraded the video a while ago. Poor 1090T was being choked :)
AMD Phenom II X6 1100T 4GHz(20 x 200) 1.5v 3000NB 2000HT, Corsair Hydro H110 w/ 4 x 140mm 1500RPM fans Push/Pull, Gigabyte GA-990FXA-UD5, 8GB(2 x 4GB) G.Skill RipJaws DDR3-1600 @ 1600MHz CL9 1.55v, Gigabyte GTX760 OC 4GB(1170/1700), Corsair 750HX
Detailed PC Specs: http://my.afterdawn.com/estuansis/blog_entry.cfm/11388This message has been edited since posting. Last time this message was edited on 8. February 2014 @ 01:28
|
Senior Member
|
8. February 2014 @ 22:31 |
Link to this message
|
|
I have router up and running dd-wrt(build23204), home network functional through built-in OpenVPN. Router sees my IPaddress from provider, but all my home devices are under a totally different network. I've had to do a few tweaks because torrent traffic + VPN encryption = the router pegs its CPU load and it has dropped its WAN connection a few times. I was able to lower the amount of active connections to keep it from working so hard and i've had better results, but after only 1 day i dont have full faith yet. If i had the process to do over again, I'd have found a router with a better CPU than the 600Mhz Broadcom chip that comes in these to help crunch the encryption better. But its only been one day, gotta wait and see what kind of uptime i get.
Time to "stress test" more by pushing large files through it...
EDIT:the original Asus firmware was feature-rich and had a good GUI.
This message has been edited since posting. Last time this message was edited on 8. February 2014 @ 22:33
|
AfterDawn Addict
|
9. February 2014 @ 14:30 |
Link to this message
|
This is going to be completely off-topic so feel free to shout at me!
I'm in the midst of looking in to how I can "easily" use an Excel spreadsheet as a backend of sorts, to pull data and display it online.
$fieldTitle
Name: $field-pulledfromExcel
DOB: $field-pulledfromExcel
And so on..
I know this can be achieved using PHP but my knowledge here is limited so I'm stuck as my Excel files have 40 sheets or so.
- It doesn't need to be dynamic, merely static, as the data is updated every 4-6 months anyway
- I do not want to embed Excel in an iFrame or anything archaic like that
- I'm not interested in setting MySQL, etc unless the conversion between Excel and that is a lot more simple than I believe it to be
Obviously Excel is a bit of a dinosaur for this sort of task but I never set out to do this; we use Excel for its intended purpose, storing data, charts, etc and I'm toying with the aforementioned idea.
Does anyone have any experience with this sort of thing and care to weigh in? Back to Google anyway. Thanks if so.
|
Senior Member
|
9. February 2014 @ 18:29 |
Link to this message
|
|
|
AfterDawn Addict
|
9. February 2014 @ 19:12 |
Link to this message
|
Thanks, appreciate the links. Yeah, I'm not sure writing loads of individual calls that I can easily bork when I decide to re-format the spreadsheet for some unknown reason is how I want to spend my time!
Tried importing my sheet into Google just for a laugh - oops!
Quote:
This document has reached the 400,000 cell per spreadsheet limit.
I think the best way would just be to do this properly - as and when I actually need to - rather than try to quick-fix something just because I can.
|
Senior Member
|
9. February 2014 @ 20:03 |
Link to this message
|
|
Sounds about right, good call on that. I've mostly linked my spread to the web,other way around, to update cells in my spread i.e., for querying updated score for the NCAA 64 Tournament, but it can cause me a headache when the web formatting or URL changes so I do my seeding and score updates manually now for that case.
I would have run into the same issue with most of my spreads plus I'm a power user so I typically use formatting and special features that programs like Google, LibreOffice, and Kingsoft Office Professional can't handle.
Even though Macro's can be great tools in Excel I typically steer clear of those too, as they can also cause you a headache as well.
Steve
|
|
yuriii
Suspended due to non-functional email address
|
10. February 2014 @ 00:53 |
Link to this message
|
|
Hope to get some good ideas about custom building PC.
|
AfterDawn Addict
15 product reviews
|
10. February 2014 @ 02:16 |
Link to this message
|
|
yuriii, what do you want to do with it? Video editing, file storage, gaming?
Do you have a fixed budget?
Movies, care to explain in a nutshell what you guys are attempting to accomplish? I understand the basic gist of using spreadsheets and Access to reference data for another document. I work with databases on regular intervals, but usually nothing much more than data entry and basic navigation of Access. Am just curious as to what the intended objective is.
AMD Phenom II X6 1100T 4GHz(20 x 200) 1.5v 3000NB 2000HT, Corsair Hydro H110 w/ 4 x 140mm 1500RPM fans Push/Pull, Gigabyte GA-990FXA-UD5, 8GB(2 x 4GB) G.Skill RipJaws DDR3-1600 @ 1600MHz CL9 1.55v, Gigabyte GTX760 OC 4GB(1170/1700), Corsair 750HX
Detailed PC Specs: http://my.afterdawn.com/estuansis/blog_entry.cfm/11388
This message has been edited since posting. Last time this message was edited on 10. February 2014 @ 02:30
|
AfterDawn Addict
|
10. February 2014 @ 03:48 |
Link to this message
|
Quote:
I've mostly linked my spread to the web,other way around, to update cells in my spread i.e., for querying updated score for the NCAA 64 Tournament, but it can cause me a headache when the web formatting or URL changes so I do my seeding and score updates manually now for that case.
I've not much experience with implementing web queries but have used spreadsheets contained them and it strikes me as just as much of a pain for that reason alone.
I also don't tend to play with macros unless I have something simple I want to automate by using the macro recorder.
Quote:
Movies, care to explain in a nutshell what you guys are attempting to accomplish?
I wanted to host an Excel spreadsheet on a webserver as effectively a backend database. I would then use PHP or a-n-other language on my website to look up the relevant data from the Excel file and display it on the webpage.
|
Senior Member
|
10. February 2014 @ 05:30 |
Link to this message
|
|
Im no expert, only taken basic classes on windows visual/.net, scripting, web development, and databases. Im familiar with many things, expert on none but it seems like this is the exact kind of application you'd want a real SQLdatabase. And from what i remember, if you already have the right formatting in place on your excel, it isnt hard to transfer that into a proper database. i remember going from excel to access to SQL but dont remember taking files straight from excel to sql but im sure once the right formatting is in place its a breeze.
|
Senior Member
|
10. February 2014 @ 06:39 |
Link to this message
|
|
That would be true that you could convert it over to a database but there might be some glitches in doing so, however that is your best bet. And once you do so it will be easier to maintain so there are good reasons in going that route.
|
AfterDawn Addict
|
10. February 2014 @ 13:44 |
Link to this message
|
|
Yeah, I think that in the longer term I will migrate to Access and then be in a better position should setting up a web accessible db become necessary. Thanks for weighing in guys.
|
AfterDawn Addict
15 product reviews
|
10. February 2014 @ 17:05 |
Link to this message
|
|
My only experience with anything similar is using systems set up by other professionals. At work we use a real-time web-based system for work orders and other things. Very easy for the boss to update it and just view current/pending projects on a smartphone from a worksite. I believe we use Access for our database, then import it into something a little more proprietary.
AMD Phenom II X6 1100T 4GHz(20 x 200) 1.5v 3000NB 2000HT, Corsair Hydro H110 w/ 4 x 140mm 1500RPM fans Push/Pull, Gigabyte GA-990FXA-UD5, 8GB(2 x 4GB) G.Skill RipJaws DDR3-1600 @ 1600MHz CL9 1.55v, Gigabyte GTX760 OC 4GB(1170/1700), Corsair 750HX
Detailed PC Specs: http://my.afterdawn.com/estuansis/blog_entry.cfm/11388
This message has been edited since posting. Last time this message was edited on 12. February 2014 @ 15:18
|
AfterDawn Addict
7 product reviews
|
14. February 2014 @ 00:16 |
Link to this message
|
|
I was gonna use my tax return to build my self-sustained generator. Today, before ordering the parts, I gave it a once over in my head. As well as some research online. One of the components requires my going back to the drawing board :( Let's just say I underestimated one of the components. So I'm gonna have to rethink it, before dropping several bones on the materials. If I were actually being paid my worth, or at least had a full time job, I'd gamble, and probably make it work. But I also suspect my car may need attention soon.
So, I guess I'm gonna have to use my return to upgrade my PC :) I think the 790XTA-UD4 has served me long enough ;) And it's certainly an agreeable board. I can probably get 30 - $50 for it? I can't believe somebody on ebay is asking $125 for a used one :S
Perhaps I can even upgrade the CPU. I'll have to think about that one though...
To delete, or not to delete. THAT is the question! |
Senior Member
|
14. February 2014 @ 23:32 |
Link to this message
|
|
So is that the same difference as Perpetual Motion? lol ;D
Probably because someone might need a replacement for a bad board in an existing system that they don't want to start all over on, as it still is cheaper buying an over priced board then a whole new system. Truly not that surprising considering equipment that you can't still buy new anymore, or they may think. I've seen products that are hard to still find new that are going for 3x or even 4x the current cost.
I'm seriously thinking about replacing my newest 8 core 4.0 GHz AMD processor with the new 4.7 GHz 220w egg cooker. It would be great I could stoke up the old PC and cook breakfast on the PC while surfing the web. :D
My ADSL ActionTec modem went out yesterday at around 10:57am so I've been without internet and trouble shooting the wiring in the house before determining that the modem maybe at fault. The funny thing is that I could still sign on to it and reconfigure it but it wouldn't negotiate PPPOe LLC/CHAP Ethernet anymore, I just got the new Netgear DM111PSPV2. The new modem is pretty sweet for a cheap ($50USD) modem. You can select two basic modes of operation, Mode Only or Router/Modem and the router has several good features. I'm very impressed how well it works and feature it is for a bottom basement product.
This message has been edited since posting. Last time this message was edited on 14. February 2014 @ 23:46
|
AfterDawn Addict
7 product reviews
|
14. February 2014 @ 23:37 |
Link to this message
|
|
It compares to perpetual motion. And in fact, it would be the closest thing I've ever heard of. But, it would not last indefinitely. Maintenance, would likely be necessary around the 2 - 4yr mark. Depending on the grade of the components, and just how taxed the device is. I still believe the device is achievable. Not so sure about small form factor just yet, but the general physics of the device is sound :p
Ultimately, I think I just felt cheap shelling out all the money LOL! :S
To delete, or not to delete. THAT is the question! This message has been edited since posting. Last time this message was edited on 14. February 2014 @ 23:39
|
Senior Member
|
15. February 2014 @ 06:49 |
Link to this message
|
|
Funny.... ;P
|
AfterDawn Addict
15 product reviews
|
17. February 2014 @ 22:38 |
Link to this message
|
|
I, for one, am HIGHLY curious to see what you build Omega. Being from an engineering and tinkering background myself, it sounds like you've had a revelation in thought and really come up with something special. The relative secrecy about its design adds to the mystique! Haha. Be sure to post updates when or if you feel it is okay to do :)
AMD Phenom II X6 1100T 4GHz(20 x 200) 1.5v 3000NB 2000HT, Corsair Hydro H110 w/ 4 x 140mm 1500RPM fans Push/Pull, Gigabyte GA-990FXA-UD5, 8GB(2 x 4GB) G.Skill RipJaws DDR3-1600 @ 1600MHz CL9 1.55v, Gigabyte GTX760 OC 4GB(1170/1700), Corsair 750HX
Detailed PC Specs: http://my.afterdawn.com/estuansis/blog_entry.cfm/11388
|
AfterDawn Addict
7 product reviews
|
18. February 2014 @ 00:03 |
Link to this message
|
|
It would give me great pleasure to share the information ;) When the time is right, you can count on it!
Looks like the mobo upgrade is gonna have to wait. I decided to go all out on a camera. I bought the Canon 70D. I wanted the 60D for so long, I finally lost my patience. And the 70D is the successor :D Apparently the 3DTV/Monitor is gonna have to wait too. Perhaps I can take on a second job, and make all my dreams come true?
To delete, or not to delete. THAT is the question! |
Senior Member
|
18. February 2014 @ 00:09 |
Link to this message
|
|
That is a great choice and the big advantage of the 70 over the 60 is the dual pixel sensor plus it is a faster body too. That will be my next camera too as like you I was going to buy the 60D.
|
AfterDawn Addict
7 product reviews
|
18. February 2014 @ 00:12 |
Link to this message
|
|
Can't wait til it gets here! ;) I'm gonna be jumping up and down when I see the package car in the driveway LOL!
To delete, or not to delete. THAT is the question! |
Senior Member
|
18. February 2014 @ 18:00 |
Link to this message
|
|
I bet that is a very good camera!!!
|
|
Advertisement
|
|
|
AfterDawn Addict
7 product reviews
|
18. February 2014 @ 18:20 |
Link to this message
|
|
Well, it should smoke the Rebel xti I've been using. And the Xti is no slouch ;) I'm gonna run it through every test I can think of. Motion, lighting, etc. I'm gonna make that camera an extension of myself LOL!
To delete, or not to delete. THAT is the question! |
