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

[ToxicBug]

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: 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!

[SoM]

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

[AmIdYfReAk]

[obsidian]

[ToxicBug]

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

[Doombrain]

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

[ToxicBug]

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.