用户活动，多个源表，大量数据 [英] User activity, multiple source tables, large data quantity

问题描述

我有4个表格(列出，重新列出，交易和出价)，我想计算出活跃用户数"，一段时间，例如"jan-mar 2008".
该表包含UserId:s和日期(ListingStartDartDate，TransactionDate等).
我要对已发布列表或在给定的时间段内进行买入交易或出价或重新上市.
注意:每个表至少包含100.000.000条记录，并且唯一用户ID的总数为4.000.000


/>结果集将存储在表中以进行报告.

任何人都知道如何有效解决此问题. SQL查询提示.. ??
Heeeelp！ :)
/Björn.

I have 4 tables (Listing, ReListing, Transaction & Bid) from wich I want to calculate "number of active users" for a time period, eg "jan-mar 2008".
The tables contains UserId:s and Dates (ListingStartDartDate, TransactionDate, etc.)
I want to count Users that has made a Listing OR a Buy-transaction OR a Bid OR a ReListing during the given time period.
Note: Each table contains at least 100.000.000 records and the total number of unique UserID:s are abaout 4.000.000

The result set is to be stored in a table for reporting perposes.

Anybody has an idea how to solve this in a effective way. SQL-query hints..??
Heeeelp! :)
/Björn.

推荐答案

你好，

感谢您的帖子.我建议将您的问题发布到位于以下位置的microsoft.public.sqlserver.server 中的讨论之一:

Thank you for the post.  I would suggest posting your question in one of the Discussions in microsoft.public.sqlserver.server located here:

希望这对您有所帮助.

祝你有美好的一天！

这篇关于用户活动，多个源表，大量数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！