Quake3World.com • View topic - Storage read/write performance: my work PC vs my $2,000 lapt

Quake3World.com Forums

Technology & Troubleshooting

Storage read/write performance: my work PC vs my $2,000 lapt

Print view

Previous topic | Next topic

Topic Starter

Topic: Storage read/write performance: my work PC vs my $2,000 lapt

ToxicBug
redline

Joined: 07 May 2006
Posts: 1272

Posted: 03-30-2012 06:35 PM

Hello,

Here's my work PC's HDD read/write:

Out of curiosity, I decided to compare it to my new laptop that I bought with a $2,000 CAD budget in mind:

Here are the differences (in x times)
Code:
Test Read Write
Seq 11.36 12.89
512K Random 19.40 11.15
4K Random 76.22 147.99
4K QD32 Random 355.69 899.95

PC specs:
Dell T1500 Workstation
Intel i3 530 @ 2.93GHz (Clarkdale)
8 GB (4x2 GB) DDR3 @ 1333MHz CL9
Seagate Barracuda 250 GB 7200 RPM 8MB SATA 3.0GB/s
Windows 7 Professional

Laptop specs:
MSI GT683
Intel i7 2670QM @ 2.2 to 3.1 GHz (Max Turbo Boost)
32 GB (4x8 GB) DDR3 @ 1600 MHz CL10
2x Intel 520 240 GB RAID-0
Windows 7 Ultimate

I'm running a MySQL server on my work PC. The database has with three MyISAM tables: 4.40 GB, 438 MB, and 69.7 MB. When I dump the database to .sql, its total size is 9 GB. I'm going to setup the same database on my laptop and do some tests on it. The queries that I'm going to run are SELECT, JOIN, and GROUP BY, usually on indexes.

Here's my question: do how much faster do you think it will run on my laptop if I do the same exact queries?

Thanks!

Top

SoM
Your Other Daddy

Joined: 03 Dec 1999
Posts: 17533

Posted: 04-01-2012 08:55 PM

for HDD higher is better, didn't u know that?

_________________
[WYD]SoM

Top

AmIdYfReAk
Elite

Joined: 10 Feb 2000
Posts: 27909

Posted: 04-07-2012 06:34 PM

Top

obsidian
I'm the dude!

Joined: 04 Feb 2002
Posts: 10423

Posted: 04-07-2012 07:35 PM

_________________
GtkRadiant | Q3Map2 | Shader Manual

Top

ToxicBug
redline

Joined: 07 May 2006
Posts: 1272

Posted: 04-11-2012 09:17 AM

I regret this purchase so bad. I don't even need a laptop

Top

Doombrain
STOP, DROP

Joined: 11 Aug 2000
Posts: 44634

Posted: 04-13-2012 08:30 AM

so you wanted to know how a DB would run on a laptop you don't even want?

Top

ToxicBug
redline

Joined: 07 May 2006
Posts: 1272

Posted: 05-29-2012 05:45 AM

Doombrain wrote:
so you wanted to know how a DB would run on a laptop you don't even want?

I already bought it, so I might as well use it. I use for testing different queries it at work once in a while to avoid stressing the main DB that's used by others.

Top

Quake3World.com | Forum Index | Technology & Troubleshooting

for HDD higher is better, didn't u know that?

I regret this purchase so bad. I don't even need a laptop

so you wanted to know how a DB would run on a laptop you don't even want?

Doombrain wrote:so you wanted to know how a DB would run on a laptop you don't even want?I already bought it, so I might as well use it. I use for testing different queries it at work once in a while to avoid stressing the main DB that's used by others.

Doombrain wrote:
so you wanted to know how a DB would run on a laptop you don't even want?

I already bought it, so I might as well use it. I use for testing different queries it at work once in a while to avoid stressing the main DB that's used by others.