Well it's a P4 based system running on Intel 865GV chipset and the sata controller supports 3Gb.
So get yourself a cheap 64GB SATA II drive.
Even running XP, you would see a performance improvement, even if you run in IDE mode and not AHCI, but no TRIM.