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
ASP.NET
|sql-server
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