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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-01-31 : 17:08:53
|
| I've got a table that records pages visited. Three are several columns which make a unique record, and I'm thinking about making the unique column set a CLUSTER.CourseID, UserID, ModuleID, DateINT, INT, INT, DATETIMEExamining for duplicate rows, I see that there are about 1000 duplicate rows (out of about 1 million rows). Duplicates don't hurt the situation (and I will need to delete them), but I'm at a loss to explain how they came to be.Particularly when the column "Date" is DATETIME. The INSERT is invoked when a user loads the ASP page. There's a call made to the database, and it's a straight-through insert using GETDATE() for the [Date] column.With GETDATE's resolution of about 300 ms, it's not possible for a user to manually submit a page that quickly (or is it?). Perhaps if he tried, but 1000 or so duplicates?Then I noticed one other detail. 99% of the duplicates are coming from one particular customer who I know is running a proxy. Is it possible that the Proxy incorrectly forwards multiple back-to-back requests occasionally?Sam |
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-02-03 : 17:42:25
|
| I don't know if this is possible Sam...butWith a proxy there is usually a somewhat noticeable delay between the user, the proxy and the site. Maybe the user is hitting the submit button multiple times because they are impatient?Select * from users where clue > 0 |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-02-03 : 20:08:45
|
| Perhaps... the proxy buffers multiple requests and they all fly at once. I suppose. |
|
|
|
|
|
|
|
|
Any thoughts on why this is duplicating?