PDA

View Full Version : How should I organize the database?


Mike
02-02-2006, 04:39 AM
My database of video cards is growing rather rapidly, and I'm beginning to think that I need to reorganize some things to keep it usable, i.e. so you don't have to scroll through 400 video cards every time you want to compare or view a card. Here are some of my thoughts I'd like your feedback on:

1. Make the drop down boxes auto-complete boxes. So instead of clicking the down arrow and scrolling, you can just start typing the name of a card and a list of matching cards pops up.
2. Sort the cards in the drop down box first by interface (agp, pci-e, etc) and then by card name, so you can quickly see just pci-e cards.
3. Make a pop-up advanced search box that dynamically changes the contents of the drop down box based on input you provide. i.e. you could hit 'advanced' then check a box for 'nvidia' and 'pci-e' and you'd get a list of matching cards to chose from.

I'm also considering how to reorganize cards in a way that prevents having a different entry for every different memory configuration of a card. So cards like the 6800 Ultra 512MB would not have a distinct card type since the only difference is the amount of memory. I'd make exceptions for cards like the 7800 GTX 512 which is obviously completely different despite the name.

I'm also thinking about doing the same thing with different memory-bus configurations of cards, and for pci/agp versions of the same card. Essentially I would be grouping cards based only on their performance. Cards with the exact same performance characteristics would be grouped into one card.

Do you guys think this makes sense?

brightblack
02-02-2006, 01:14 PM
This is an interesting conundrum. On one hand you want people to be able to get where they need quickly without a lot of clicking, but on the other hand, you want people to browse around a little bit. If you had a third hand, you could also say you need it to be scalable for some time.

I'd probably hit: bus (PCIe/AGP now) then a selection from chip designer (ATI/nVidia/3dfx/Matrox) then something related to generation family or similar. This might aid the scaling side of it.

One underrated column on that page though I think is the release date. It's pretty cool to see how old/new cards were before I bought them!

Hope this helps.

phranq
02-02-2006, 06:32 PM
option #2 seems the best way to cut down the size of the list without a lot of clicking everywhere.