-
Notifications
You must be signed in to change notification settings - Fork 23
TASK: Update topic URLs #1878
Copy link
Copy link
Labels
databaseChanges to database schemaChanges to database schematasksGeneral maintenance tasks that aren't typical developmentGeneral maintenance tasks that aren't typical development
Milestone
Metadata
Metadata
Assignees
Labels
databaseChanges to database schemaChanges to database schematasksGeneral maintenance tasks that aren't typical developmentGeneral maintenance tasks that aren't typical development
Type
Fields
Give feedbackNo fields configured for Task.
Topic URLs are stored in table `activeforums_Topics'.
Add persisted computed column URL_Hash using hashbytes and md5
add index on URL_Hash
All sql changes go into SqlDataProvider file with version and issue number in the file name
In the TopicController add a FindByURL function to use the computed hash for speed and then non-hash URL for deduplication and accuracy, returning a matching topicinfo object