Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edb2003
Yak Posting Veteran
66 Posts |
 Posted - 2003-11-19 : 00:38:39
|
| Greetings again, Looking at Books Online, I discovered that my .Net project requires a lot of Sumarizing Data. It suggests using DTS or Analysis Services. I have a table with about 100,000 records. Which of the 2 above has better performances in doing multiple summaries off a table? Is there a snippet that can tell me how to grab the sums of various stored procedures based on one table. For example, I have a table that has data of daily, monthly hits per page, percentage, viewer, goal hits per page, Daily leads, daily goal on leads, based on search engines (Google, Altavista, Yahoo, etc.). I need to get totals off of a variety of these fields.I appreciate everyones help :)Happy Day,edb |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-19 : 02:09:42
|
If you have only one table, use neither. It might not be worth the trouble setting up and using Analysis services at least. Just write a simple (or complicated, if you like) Stored Procedure to aggregate the values and put them into a reporting table. Then create a job scheduled to run the SP every day or every few hours depending on your permissible reporting latency. Owais
Where there's a will, I want to be in it. |
 |
|
|
edb2003
Yak Posting Veteran
66 Posts |
Posted - 2003-11-19 : 10:35:29
|
Good Morning to all and thanks for the input. However, in the future with this company, their messy non-normalized data will be crying for something. They not only have 1 table with 100,000 records. They have other tables not needed for this project but ... in the future ... may need to normalize all of their data. Picture this. A database with non-normalized data, a bunch of ins_items, del_items, and sel_items as stored procedures.I implore some guidance as I am new to this and need to add a layer above my understanding of Stored Procedures.Which has the best performance, DTS or Analysis Services?What are the pros and cons of each if it is difficult to assess?I appreciate your help.Thx,Edb |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-19 : 21:02:40
|
quote:
Which has the best performance, DTS or Analysis Services?
That's kinda like asking which is better, chocolate or Beethoven's 9th Symphony? DTS and AS are different things. And just because that book suggested them doesn't mean either of them are the right tool for the job.DTS transforms and copies data from one source to another. By itself it won't do anything to help you summarize data, and you don't need it at all to do so. AS is geared towards summarizing and providing data in ways that permit extremely detailed and complicated analysis. It is overkill for your needs, and you'll probably get frustrated trying to pick it up now. It's definitely something you work your way up to, not start off from scratch with.I agree with Owais, you don't need DTS or AS to accomplish basic data summarization. I've done similar things a number of times with simple INSERT INTO...SELECT...GROUP BY queries. Don't start with the most elaborate solution first, try the simple ones first and test them. If they're totally inadequate, THEN move on to the more complicated solutions. If you're worried about the solution being able to scale up to more rows, create a copy of the database and genrate lots of sample data, and test the solution on that. Only testing will tell you how something will perform. |
|
|
|
|
|
|
|
|
DTS or Analysis Services ... Which is good?