I have a few questions for the SQL guru here ... In short, this is an advertising management system in which the user can define campaigns for different countries, categories, languages. I have few questions, so help me with what you can.
As a rule, I use ASP.NET, and I want to cache the entire result set of a specific user as soon as he requests statistics for the first time, so I will avoid big round trips to the server.
any help is appreciated
Click here for a chart with all the details you need for my questions.
1. The main problem of this application is to show the user how many clicks / impressions there were and how much money he spent on the campaign. What is the easiest way to get this information for him? I will also include filtering by date, date ranges and several other parameters in this statistics table.
2. Another problem is when the user tries to edit the campaign. The old campaign will die, which means that if the user sets $ 0.01 as campaignPPU (pay-per-unit), and the next day updates it to $ 0.05, everyone will reset to $ 0.05.
3. If you could redesign some parts of the table design to be more flexible and easier to change, how would you do it?
Thanks ... sorry for doing such a great job, but some SQL guys might be interested.