OpenACS

donb
committed
MAIN:donb:20051110011426
on 10 Nov 05
Replaced two slow queries using cc_users with their faster equivalent using
parties and users. Makes a huge difference on Oracle when there… Show more
Replaced two slow queries using cc_users with their faster equivalent using

parties and users.  Makes a huge difference on Oracle when there are many,

many users (49,000 in this case).  And yes, I checked, the original queries

used indexes galore, Oracle was doing as well as can be expected.

Show less

/www/unsubscribe-members.xql (+0 -1)
1 1 <?xml version="1.0"?>
2 2
3 3 <queryset>
4       <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
5 4
6 5     <fullquery name="update_autosubscribe_p">
7 6         <querytext>
8 7             update forums_forums
9 8             set autosubscribe_p = 'f'
10 9             where forum_id = :forum_id
11 10         </querytext>
12 11     </fullquery>
13 12
14 13 </queryset>