Andy Edinborough

less info
111 reputation
1
bio website andy.edinborough.org
location Wichita, KS
age 31
visits member for 3 years, 8 months
seen Apr 3 '12 at 20:51

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