Thread of PC Woes, Troubles, Problems, and Issues

Why not move PostgreSQL to a nix box. PostgreSQL will definitely run faster on Linux than on Windows. It is designed for a Unix style architecture, and implements this same architecture on Windows, which means it does a number of things that Windows isn't designed to do well. It works fine, but it doesn't perform as well.For example, PostgreSQL uses a process-per-connection model, not threading. Windows is designed to do threading. If your application does lots of connect and disconnects, it will definitely run significantly slower on Windows, for example.There is also some assumptions around the filesystem which don't exactly favor NTFS.The one thing you really need to think about - if you are on Windows, most antivirus products will bug out when used with PostgreSQL, because they are not used to this type of workload (such as 1000 different processes reading and writing to the same file through different handles). That means that the strong recommendation is to always uninstall any antivirus if possible (just disabling it or excluding the PostgreSQL processes/files is often not enough). And this is not just for performance reasons, but also stability under load.
 
Just seems my opinion isn't worth anything if they ask and then don't even bother taking my thoughts on board.
 
BeoTeK said:
Just seems my opinion isn't worth anything if they ask and then don't even bother taking my thoughts on board.
Click to expand...

Well, I like the "best tool for the job" approach. Taking Oracle, MySQL, MSSQL and PostgreSQL into account my conclusion is as follows :

Oracle is the Relational database management system to use if you have massive databases that need near real time transaction processing with all the bells and whistles.
MySQL is if you want all of the above but you don't want to pay for it.
MSSQL is super simple to implement and performs VERY well in 99.999% of the use cases. Clusters easily and as a result scales well. Comes at a relatively decent price with loads of pricing points and extremely good support which is why its so widely used.
PostgreSQL is a bit of a relic, not quite as widely used as any of the above. Lacks some features that could make it stand out.

Most notable is that Oracle and MySQL (possibly because they come from Oracle corporation) both support in-memory databases. MSSQL and Postgre do not; MSSQL has it on the roadmap for sometime when they feel like it, but no word from the Postgre boys.
 
I want my work laptop to automatically connect to a certain network drive, how would I do it?

Currently my G drive connects to \\derp\data\more_derp\ on each startup, however I want it to connect to something else (\\herp\data\more_herp\). I can do this manually, however each time my laptop restarts it reverts back to the derp network drive. Is this something I can do myself (I have admin rights however some things are still blocked for me) or would IT have to sort it out for me?

I also want it to be my G drive, because if it is another drive (like Z) some of the documents don't work properly because the hyperlinks get all screwy.
 
net use [{devicename | *}] [\\computername\sharename[\volume] [{password | *}]] [/user:[domainname\]username] [/user:[dotteddomainname\]username] [/user:[username@dotteddomainname] [/home {devicename | *} [{password | *}]] [/persistent:{yes | no}] [/smartcard] [/savecred] [/delete] [/help] [/?]
Click to expand...


net use G: \\computername\sharename /persistent:yes
eg. net use G: \\herp\data\more_herp /persistent:yes
Click to expand...

a good example http://www.howtogeek.com/118452/how-to-map-network-drives-from-the-command-prompt-in-windows/
 
Last edited:
Blazzok said:
I want my work laptop to automatically connect to a certain network drive, how would I do it?

Currently my G drive connects to \\derp\data\more_derp\ on each startup, however I want it to connect to something else (\\herp\data\more_herp\). I can do this manually, however each time my laptop restarts it reverts back to the derp network drive. Is this something I can do myself (I have admin rights however some things are still blocked for me) or would IT have to sort it out for me?

I also want it to be my G drive, because if it is another drive (like Z) some of the documents don't work properly because the hyperlinks get all screwy.
Click to expand...

http://www.mobilenetswitch.com/Download/MobileNetSwitch.msi
 
PsychoFish said:
http://www.mobilenetswitch.com/Download/MobileNetSwitch.msi
Click to expand...

DarkStarZA said:
You could try the net use command

From command prompt, run: "net use G: /delete" (to delete the existing)
Then run: "net use g: \\herp\data\more_herp\ <password> /user:<domain>\<username> /savecred /persistent:yes" to add the new one using different username/password than yours, save the credentials and remain after reboot.

More info here: http://pcsupport.about.com/od/commandlinereference/p/net-use-command.htm
Click to expand...

Thank you gentlemen, I will give it a whirl and see if it works :)
 
Blazzok said:
Thank you gentlemen, I will give it a whirl and see if it works :)
Click to expand...

image.png
 
BeoTeK said:
Thanks mate, really good price on that X52.
Click to expand...

Yeah it is, I actually have the Hotas X, pulled it out the cupboard yesterday lol
My client says the X52 is one of his fav ones, almost on par with the X55 according to him. (He has a full on custom cockpit flight sim rig)
 
The Joker said:
Yeah it is, I actually have the Hotas X, pulled it out the cupboard yesterday lol
My client says the X52 is one of his fav ones, almost on par with the X55 according to him. (He has a full on custom cockpit flight sim rig)
Click to expand...

Sweet, just looking to see the difference between x52 and x52 Pro (which I don't see on Rebeltech).
 
[MENTION=21]The Joker[/MENTION] - Do you get any commission or anything? I know you punt Rebeltech a lot, do I order from you or directly from store? Does it matter?
 
BeoTeK said:
[MENTION=21]The Joker[/MENTION] - Do you get any commission or anything? I know you punt Rebeltech a lot, do I order from you or directly from store? Does it matter?
Click to expand...

You can just order directly through them bud, you'll have a pleasant experience :)

I don't get commission from them :P but I do get my hands on the latest and greatest tech and I don't mind punting them at all as I know all the staff really well and have been friends with them for years. Best online PC store in SA by miles.
 
The Joker said:
You can just order directly through them bud, you'll have a pleasant experience :)

I don't get commission from them :P but I do get my hands on the latest and greatest tech and I don't mind punting them at all as I know all the staff really well and have been friends with them for years. Best online PC store in SA by miles.
Click to expand...

So.... who will take over your roll or position with them once you're gone? ;)

*nudge nudge*
*wink wink*
 
The Joker said:
Yeah it is, I actually have the Hotas X, pulled it out the cupboard yesterday lol
My client says the X52 is one of his fav ones, almost on par with the X55 according to him. (He has a full on custom cockpit flight sim rig)
Click to expand...

So... are you using yours? If not, consider [-]selling[/-] donating? ;)











:p
 
So quick case fan debate, Bitfenix Spectre Pro vs Arctic F12 PWM vs Coolermaster Sickleflow
Which one has Best CFM with the lowest Noise levels?

Thinking of getting the Spectre to replace my Hyper 212X fan, that I believe is worn or something because it keeps hitting the fan's cable causing much irritation to my life.
 
ok so I kinda have an idea of what the problem is but there's no harm in getting more opinions :)

So I got a "new" GPU. A Radeon HD 7870 XT.

I put it in and nothing happens. Monitor does not get a signal from the card

I updated the mobo bios and more stuff broke. Like now windows won't recognise my wifi dongle so I lost the internet as well now. and it takes forever to boot up now. but that's a separate issue. my main problem is the GPU

Any thoughts?
 
You must log in or register to reply here.
Back
Top