why #5 Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
??????????
why #5 Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
??????????
Because for displaying this 3 fields in the report the database statement is more sophisticated and needs more cpu time.
I fixed all the links in the mainpost (linking to the proper FAQ links)
And added a Buying a New Computer Guide: Buying/Building a New Computer optimized for HoldemManager + PostgreSQL.
Ranging from mid-end <$1000 (incl. monitor) - to high-end $2700)
It might be fun to also further discuss HARDWARE UPGRADE recommendations in this topic to improve HEM performance.
Thx.
I am planning (hoping) to build a hi-performance PC this fall. Something similar to this.
1 - Intel Core i7 920 Nehalem 2.66GHz LGA 1366 130W Quad-Core Processor Model BX80601920
1 - GIGABYTE GA-EX58-UD3R LGA 1366 Intel X58 ATX Intel Motherboard
2 - OCZ Vertex Series OCZSSD2-1VTX30G 2.5" MLC Internal Solid state disk (SSD)
1 - Western Digital Caviar Black WD5001AALS 500GB 7200 RPM SATA 3.0Gb/s 3.5
1 - Western Digital Caviar Black WD1001FALS 1TB 7200 RPM SATA 3.0Gb/s 3.5
1 - MSI N9600GT-MD1G GeForce 9600 GT 1GB 256-bit GDDR3 PCI Express 2.0 x16 HDCP Ready SLI Supported Video Card
1 - Patriot Viper 6GB (3 x 2GB) 240-Pin DDR3 SDRAM DDR3 1333 (PC3 10666) Desktop Memory Model PVT36G1333ELK
1 - CORSAIR CMPSU-850TX 850W ATX12V 2.2 / EPS12V 2.91 SLI Ready CrossFire Ready Active PFC Power Supply
1 - Antec Nine Hundred Black Computer Case With Side Panel Window
1 - PLEXTOR 24X DVD/CD Writer Black SATA Model PX-880SA LightScribe Support
1 - Microsoft Windows Vista Home Premium SP1 64-bit for System Builders
Grand Total: $1,501.90
There is a new Western Digital Caviar Black 1.5TB!
I recently build:
(Really Happy with)
Intel i7 920 CPU
Scythe Mugen-2 CPU cooler
OCZ Platinum XTC 6GB - CAS7 DDR3 RAM
Sapphire VAPOR-X HD 4870 1GB GDDR5 PCI-E videocard
2x OCZ Vertex 30 GB SSD harddisks RAID0 (new firmware was released yesterday, they just keep getting faster with every new OCZ firmware tweak.... so happy I didn't get a Intel X25-M G1 which Intel will no longer support after only 12 months. They will not release TRIM for the X25-M G1, only for the G2 Postville)
Samsung 223B DVDburner
Logitech G15 v2 Keyboard and Logitech G9 Mouse
Windows 7 ULTIMATE build 7600 x64
(Would Have Bought Something Else, Had I Known...)
MSI X58 Pro-E mainboard: I would have bought the GIGABYTE GA-EX58-UD3R had I known the MSI mainboard has a horrible IOH (that's the Intel Northbridge chip) heatsink. I had to buy a separate Thermalright HR-05 and change the heatsink.
Samsung Spinpoint F1 1TB SATA harddisk: great harddisk, but Samsung released an even better F3 series, two weeks after I bought mine.
Antec Sonata Plus 550 case (incl. 550w power supply): I bought this case for its clean looks and its supposedly QUIET fan, and QUIET power supply. The great thing about the case is the unique way how it mounts the 2.5 inch SSD harddisks (withouth the need for any 2.5-->3.5 bracket, I was impressed) and its removable dust filter. BUT.... it's not THAT quiet, it has no removable mainboard tray, the "workspace" inside is a bit too small (found out that really sucks, since I had to remove the mainboard twice to change the IOH heatsink) And it's a bit expensive.
Also my Intel i7 920 is never really used. My computer (running HEM + PostgreSQL + multitabling + internet browser + downloading + MSN, etc.) only uses 10% of its processor power. The i7 comes with expensive X58 mainboards. I might have bought a AMD Phenom x4 instead and spend the saved $100 on.... another 30GB Vertex? Or towards 2x Intel Postville
Last edited by Patvs; 08-14-2009 at 07:37 PM.
You are running SQL on the RAID with the OS? How is bulk import speed?
You are making me consider the same now, but I think I want my SQL DB on it's own SSD, independent of the OS, for speed and data security.
I had 3 options with my 2x SSD.
-1 use one for OS and one for SQL (non-RAID)
-2 running SQL on the RAID with the OS on one partition (RAID)
-3 OS and SQL each on their own partition (RAID)
I've only tried #2, thinking RAID would be fastest and the data is really secure (despite RAID, because the SSDs are really reliable).
---
Bulk import speed test:
Test 1: 3x 40 MB txt files (total 84.000 hands). (the 3 largest files from a once "export hands" database, each 40 MB text file contains 28.000 hands)
This took 14 minutes to import, 90 hands /s. (it took about 30 seconds of analysing the files before the actual importing began)
Test 2: 1000 handhistory files in 25 subfolders (total 120 MB, each file ranging from 1Kb-500Kb: average filesize 120Kb) (50.000 total number hands)
This took 18 minutes (half of the time spend on the last 250 files!), 45 hands /s (it was importing with 70 hands /s for the first 750 files, but after that the importing would often freeze for a minute and the "files imported 750 of 1000" would suddenly JUMP to "770 of 1000" instead of to 751. After each "freeze" the hands xx / s would drop.
(CPU max 10%, RAM max 30%, FullTilt poker handhistories all Full Ring Cash (9 handed), used IMPORT from folder, NO duplicate hands)
I'm guessing you can get a lot higher speeds if OS and SQL are installed on separate drives? But lets suppose I add 2 drives. Will 2 drives for OS in RAID + 2 drivers for SQL in RAID,..... be faster than just OS + SQL on 4 drives in RAID?
Last edited by Patvs; 08-17-2009 at 08:29 PM.
i followed the steps to purge hh, but i am still able to view/replay hands that should have been deleted.
Lets rephrase that.... If you have 2x SSD harddisks in RAID0.... and 2x "normal" 7200 RPMs in RAID0 (or 2x VelociRaptors), would it still make sense to install Windows on one RAID array and your PostgreSQL database on the other SSD RAID array. Or should BOTH simply be installed on the FASTEST array?
Any idea what causes my import speeds to freeze/lag (resulting in a big hands/s drop) after 750 files if I import 1000 files at once?