** Quick Questions & Answers Thread ** LC / OT (aka: "Ask _dave_")

[ollu]

Originally Posted by _dave_

If you don't know about command line I wouldn't try that for now.

In my PgAdmin, once you've "connected to server" - it's in the menu at the top at "Tools -> Restore"

it may restore straight off the bat, or you might need to use HEM to create a new empty database first to restore into.

The thing is, the restore button from the tools dropdown menu is not active, i cannot click on that

[_dave_]

you need to "connect to the server" first, from the treeview on the left side of PgAdmin

[ollu]

i have done that, but still cant push restore

[_dave_]

oh, it seems you need to have selected in the treeview a database, nothing else will do. If you don't have any, right click -> new database will get you one.

[steel108]

I didn't want to start a thread in CTH forum over something so trivial so figured I would post here:

I had 16GB of RAM installed (4x4GB), but I had to remove one to insert a new CPU fan (i7-2600k stock fan SUCKS). I have 12GB now and the motherboard booklet said something about only using 3 slots instead of 4, but I had no clue what it meant and I threw away the booklet. What are the effects of only using 3 slots? I remembered something about averaging 2 of the slots or something...... Thanks.

[_dave_]

no big deal. chances are it's talking about a "dual channel memory controller", so it goes a tad faster if it has only pairs to work with.

oops I read wrong! below answer is correct. it should be slightly faster in threes, the intel i7 has a triple channel memory controller.

[ItsOnlyChips]

@steel108

DDR3 memory works more efficiently in sets of three

if u want to be absolutely sure about the memory config, the motherboard manual is easily downloadable via the manufacturer's website

might be worth ur time to check it because some motherboards specify certain slots to use for maximum efficency

[Tyler]

anyone know how to have an AHK automatically send a hotkey when a new table becomes active on Merge? Merge's wingetclass is 'swt_window0'.

i'm trying to make a merge betpot

[_dave_]

easy enough method: (not tested code)

method: repeadedly get the id of active window, keep note what it was before and see if it's changed yet

currentwin := "" ; make a variable to compare against later
SetTimer, CheckMergeActiveWindow, 1000 ; run every second

CheckMergeActiveWindow:
Winget, id, id, A ;get the id of currently active window
Wingetclass, class, ahk_id%id% ; get it's class
if (class == "swt_window0") 
{
  ; it's a merge window
  if (id != currentwin)
  {
    ;doesn't match so it's a different window
    currentwin := id ; save it's id for next comparison
    ; do whatever function is wanted here
  }
}
return

[Tyler]

Thanks, but it gives me two errors. Probably easy to fix but I don't know how:

[_dave_]

edited above, may work now. I had :: (hotkey identifier) instead of a single : (subroutine identifier)

and the WinGet line was missing a parameter.

I did say untested (still is btw, i'm just typing it straight in to 2p2)

[Tyler]

Thanks! I got it to work by changing

if (class == "swt_window0")

to

if class=swt_window0

[greg nice]

== is case sensitive

[steel108]

After figuring out what to search for based on the language used in the responses, everything seems to say that the Sandybridge uses dual memory. I'm still trying to figure out if using 3/4 will have any negative impact.

[_dave_]

googling to confirm it seems sandy bridge platform is indeed dual channel for now.

it sure won't be anything serious. slight drop off in benchmarking numbers if it's not in ideal configuration. I certainly wouldn't lose another 4GB just to make it "balanced".

you can always test it though, memtest86 gives you throughput numbers, and I'd imagine most benchmarking programs do too. I'm not familiar with what is current these days though.