One major consideration should be an ability to get good compatible drivers for the card that match your choice now or future choice of operating systems. You won't gain much by buying new high performance cards with AGP 8 and such. This card might work fine....again, it's as much the drivers as the hardware. Also, do you want the ability to play DVD video? Might I suggest, and I know some will disagree, that you get a basic Riva TNT based (or TNT-2) card and use the Nvidia reference drivers which are available on their site. These seem to be rock solid. I believe they have the MPEG hardware capability needed to play your DVDs if you hope to do such. Newer and higher priced cards will fit your system and reduce their AGP speed but will not offer much benefit if you attempt to use them to capacity. Again, my thoughts only.
I've posted an earlier question and received some excellent (and I might add, ever so grateful) advice-help. So I thought I'd post this one. I need a video card, but my head is spinning from a weird mass of terminology! I do know and understand that it must be AGP. Now my motherboard manual (ASUS P3B-F) states that "AGP bus frequencies above 66MHz exceed the specifications for the AGP interface and are not guaranteed to be stable" I only need a basic, low cost card. So the one I'm looking into is as follows. Would this be a compatible card?
Pine SiS 315E Video Card / 32MB / AGP 4X
Performance
GPU/VPU
SiS 315E
RAMDAC
375 MHz
Maximum Resolution Learn More
2048 x 1536 @ 85Hz
Memory
Video Memory
32MB
Memory Type
SDRAM
Core Clock
166 MHz
Memory Clock
143 MHz
Memory Bandwidth
2.7GB/sec.
Connections
Interface Type
AGP
Interface Speed
4X
Connector(s)
VGA
System Requirements
Operating Systems
LINUX
Windows

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic