[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

Hard Drive,

I need a new hard drive at the moment i am using SATA 8mb 80GB hard drive. My current work involving read/write a huge date 6 GB dataset,  For some reaosn I found that my current drive is too slow.

So I am thinking to buy new hard drive ... what technology and brand do you recommend for my case? Could you please be specific what brand should I buy when giving an advise to me. Well kind of confused of terms IDE And SCSI, SATA , etd


cheers,
0
sutejok
Asked:
sutejok
  • 2
  • 2
  • 2
  • +3
2 Solutions
 
burrcmCommented:
I suspect that your drive is not the problem, but rather your database requires indexing to speed up queries. Perhaps the drive requires defragmenting also.

Chris B
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
burrcm makes some good points.  

However, if you are certain it's the drive and you have lots of queries you might want to consider using RAID.  You would need a RAID controller ($50-$100 or more, depending on type), and you would need a minimum of 2 hard drives, 4 recommended, and/or any even number of drives above 4.  Read over: http://www.pcguide.com/ref/hdd/perf/raid/levels/index.htm

A RAID 10 (1+0) would provide you with an effectively faster disk access speed.

Also:

ATA - standard hard drives most people have been using the last 10 years or so.  Cheapest with fair performance; up to 133 MB/sec throughput to the system with a maximum of 7200 RPM.   (Most new drives are 7200 RPM)

SATA - new standard in hard drives.  Beggining to replace ATA drives.  up to 150 MB/sec throughput to the system with a maximum of 10,000 RPM (though most drives are 7200 RPM).   Drives tend to cost 10% more than comparable ATA drives though you can find deals where they might even cost less.

SCSI - OLD, OLD standard for hard drives which has been around for roughly 20 years.  The standard has been updated several times and NEW drives are capable of transferring data at 320 MB/Sec throughput to the system and have rotation speeds of up to 15,000 RPM, making these drives clearly faster than either SATA or ATA, BUT, they cost noteably more and don't come in as large sizes.  A 146GB SCSI drive might run $500-1000 where a 160GB ATA is under $100.
0
 
sutejokAuthor Commented:
My work involved reading from this dataset :
http://www.ll.mit.edu/IST/ideval/data/1999/1999_data_index.html
which contains GBs datasets i.e I need week1-5.

Do you think SCSI it wll make a significant different when reading this dataset? Which one is faster ? RAID with 4 hard drives or SCSI?

Also what is Enterprise SATA?
http://www.wdc.com/en/products/Products.asp?DriveID=65&Language=en

Say for example for a server, do they run in SCSI or RAID?


0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
WatzmanCommented:

Like Burrcm, I suspect that you are barking up the wrong tree and that the drive is not the problem in terms of speed.
0
 
rindiCommented:
I don't think the drive is the reason for your performance problem either.

Servers usually use many SCSI disks in raid5 configuration. Raid 5 needs at least 3 disks, one of which the capacity is lost for redundancy. The more disks you have the higher speed you get, as tll disks get data at the same time.

Modern servers today also start coming with SATA disks, after all, it is much less expensive than SCSI.

But, normal Servers always use raid.
0
 
sutejokAuthor Commented:
OK, so how to do indexing and defrag on Linux system? btw, I am using replayfs
0
 
burrcmCommented:
Well you have jumped off my branch. "linux defrag" into google indicates that there are plenty of options in this regard.

Chris B
0
 
rindiCommented:
Also, modern databases are usually indexed internally, not by the filesystem. Check the documentation of the database system you are using.
0
 
Pauli150Commented:
Linux file systems don't NEED to be defragged, unlike windows they are properly programmed.

if you are accessing huge files, increase the cluster size to like 64k or more. Larger clusters will allow faster usage of your hard drive.

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now