network profile
| bio | website | andy.edinborough.org |
|---|---|---|
| location | Wichita, KS | |
| age | 30 | |
| visits | member for | 2 years, 5 months |
| seen | Apr 3 '12 at 20:51 | |
| stats | profile views | 3 |
|
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 |
