We also tend to leave out the ID field and just use (UserID, SongID) as the primary key. When these are the only fields in the table, you're not losing anything by using a hybrid key and you're saving a lot of space with so many records.
4,000,000 records isn't really all that many for a table that has just two integer fields. Sam At 08:50 AM 1/17/2003, you wrote: >You could create a database like this: > >ID|USERID|SONGID >1 1 222 >2 1 443 >3 1 9494 >4 2 999 >5 2 443 etc... > >This can possibly grow to be HUGH ... (100,000 users X 40 = 4,000,000 >records). > >But with stored proceedures and good indexing you should be fine. > >Paul Giesenhagen >QuillDesign ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
