Page 1 of 1

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

Posted: Sat Mar 31, 2012 2:35 am
by ToxicBug
Hello,

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

Image

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

Image

Here are the differences (in x times)

Code: Select all

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!

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

Posted: Mon Apr 02, 2012 4:55 am
by SoM
for HDD higher is better, didn't u know that?

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

Posted: Sun Apr 08, 2012 2:34 am
by AmIdYfReAk
Image

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

Posted: Sun Apr 08, 2012 3:35 am
by obsidian
Image

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

Posted: Wed Apr 11, 2012 5:17 pm
by ToxicBug
I regret this purchase so bad. I don't even need a laptop :tear:

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

Posted: Fri Apr 13, 2012 4:30 pm
by Doombrain
so you wanted to know how a DB would run on a laptop you don't even want?

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

Posted: Tue May 29, 2012 1:45 pm
by ToxicBug
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.