That motherboard is so old I couldn't find any information about it except that it uses a Pentium 4 processor and has an AGP 4x slot. The processor itself is an immediate bottleneck and since you have an AGP slot, you most definitely are using ATA and not SATA.
To make use of the, "largest" and, "fastest" hard-drive(s), you would have to buy yourself an X58 motherboard with an i7 processor. Which I doubt you want to dish out that sort of money.
So instead, this is perhaps the fastest and the largest hard-drive your computer will be able to make use of:
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136111If you want to view all available hard-drives, visit
this website. Afterward navigate to Computer Hardware>Hard Drives. Now on the left select, "Internal Hard Drives." Now on the left select, "IDE Ultra ATA100" located under, "Interface."
Those are the only hard drives your system can use, and out of those I already showed you the fastest one.
Let me know if I can help you further or if I can explain anything I mentioned above in more detail. I'm sorry you can't use the latest and greatest, however those are designed for the fastest systems on the market.