Bug 113673

Description of problem:

The getTxns method generates a query that looks like


select vt.id as c_1,
       vt.modifying_ip as c_2,
       vt.timestamp as c_3
  from vcx_txns vt
       left join vcx_obj_changes voc on voc.txn_id = vt.id
       left join vcx_obj_changes changes__voc on changes__voc.id = voc.id
 where (changes__voc.obj_id = 19628)
 order by vt.id desc;

This takes 100ms to execute on my current server populated with 4000
items.

Re-formatting it as

  select vt.id, 
         vt.modifying_ip, 
         vt.timestamp 
    from vcx_txns vt, 
         vcx_obj_changes voc, 
         vcx_obj_changes changes__voc 
   where voc.txn_id = vt.id 
     and changes__voc.id = voc.id
     and changes__voc.obj_id = 19628 

Reduces it to 7ms

This is on PG 7.3.2 / RHEL 2.1. Attaching explain plans and other
interesting info.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info: