Store in DB or not to store ?

Posted by eugeneK on Stack Overflow See other posts from Stack Overflow or by eugeneK
Published on 2010-05-25T12:14:35Z Indexed on 2010/05/25 12:21 UTC
Read the original article Hit count: 448

Filed under:
|

There are few string lists in my web application that i don't know where to store in DB or just class.

ie. I have 7 major browsers with which users enter the site. I want to save these stats thus i need to create browser column in UserLogin database. I don't want to waste space and resources so i can save full browser name in each login row. So i either need to save browserID field and hook it up with Browsers table which will store names following db normalization rules or to have sort of Dataholder abstract class which has a list of browsers from which i can retrieve browser name by it's ID...

The question what should i do ? These few data lists i have contain no more than 200 items each so i think it makes sense to have them as abstract class but again i don't know whether MS-SQL will handle multiple joins so well. Think of idea when i have user with country,ip,language,browser and few more stats ..

thanks

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql-server