Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1
Newest
 Student
Impact
~851 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Mar
27
comment Speeding Up Querying Views
The view is a critical piece of logic. The conditions under which rows would be added or removed are extremely varied.
Mar
27
comment Speeding Up Querying Views
-Well, I believe they're as reasonable as they can be. :] -Yes, all the indexes possible are being used, which is why I'm trying to index a view. -This procedure is the main function of our site. Sometimes hit a couple times for a single request (although much work has been done to reduce that). -A few seconds of stale data certainly isn't the end of the world. Actually, my idea was to run the update in a separate process while doing something like read uncommitted so the user would never be blocked (or only minimally so).
Mar
25
awarded  Student
Mar
25
asked Speeding Up Querying Views