Overclock.net banner
1 - 6 of 6 Posts

·
Registered
Joined
·
728 Posts
Discussion Starter · #1 ·
First of all, I don't know anything about it. However, I play poker for a living and my tracking software is using this heavily. Does anyone know anything about it? Does it benefit from extra cores? I don't do much gaming but I work a lot and convert video files...so I'm trying to decide if I'd benefit from a 1075T for example over an i7 950 (while saving a little as well). Any tips would be appreciated.
 

·
FS19 Addict
Joined
·
5,392 Posts
Did a bit of reading and I think it can take advantage of multiple core(dual-core at minimum). It seems a large cache and good clock speed would be beneficial. Do you have a rig now you want to upgrade or building new. I suggest getting a 6 core with lots of cache. Either CPU company should do, for best p/p try the 1075T or 1090T. Reliable and fast hard drives, as well as good amount of RAM(6-12GB) would be another thing to look into.

http://www.commandprompt.com/blogs/j..._requirements/
http://www.postgresql.org/files/docu...w_performance/
 

·
Registered
Joined
·
1,344 Posts
Quote:

Originally Posted by Rick Arter View Post
Did a bit of reading and I think it can take advantage of multiple core(dual-core at minimum). It seems a large cache and good clock speed would be beneficial. Do you have a rig now you want to upgrade or building new. I suggest getting a 6 core with lots of cache. Either CPU company should do, for best p/p try the 1075T or 1090T. Reliableand fast hard drives, as well as good amount of RAM(6-12GB) would be another thing to look into.
6-12GiB would be 2x3GiB or 3x3GiB respectively, which would mean triple channel. AMD does not support triple channel memory yet. So you'd either want 4GiB or 8GiB.

Also, since you're doing video editing, get the Phenom II 1075T over the Core i7 950, since those programs will benefit from having more physical cores.
 

·
Premium Member
Joined
·
65,162 Posts
It really depends on the implementation and what you plan to do.

You can do a lot to optimize SQL... table partition, caching, query structure, temp tables, indexing, inner/left joins, bulk loading, commit levels, table statistics, ect.

While hardware helps, there is usually more benefit in optimize the software first.
 

·
Registered
Joined
·
728 Posts
Discussion Starter · #5 ·
Quote:

Originally Posted by Rick Arter View Post
Did a bit of reading and I think it can take advantage of multiple core(dual-core at minimum). It seems a large cache and good clock speed would be beneficial. Do you have a rig now you want to upgrade or building new. I suggest getting a 6 core with lots of cache. Either CPU company should do, for best p/p try the 1075T or 1090T. Reliable and fast hard drives, as well as good amount of RAM(6-12GB) would be another thing to look into.

http://www.commandprompt.com/blogs/j..._requirements/
http://www.postgresql.org/files/docu...w_performance/
Interesting. Yeah, I'm building from scratch...buying a couple of things every week. The drive with my programs will be an SSD...and I didn't plan on skimping on RAM, so that should all be good.
 

·
Registered
Joined
·
728 Posts
Discussion Starter · #6 ·
Quote:

Originally Posted by DuckieHo View Post
It really depends on the implementation and what you plan to do.

You can do a lot to optimize SQL... table partition, caching, query structure, temp tables, indexing, inner/left joins, bulk loading, commit levels, table statistics, ect.

While hardware helps, there is usually more benefit in optimize the software first.
Yeah...hmm. I don't really know anything about any of this stuff. I bought the program that uses the postgresSQL and just let it do its thing.
 
1 - 6 of 6 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top