Bug 215814 - [performance] Duplicate Queries between Table and Remote Systems View
Summary: [performance] Duplicate Queries between Table and Remote Systems View
Status: RESOLVED FIXED
Alias: None
Product: Target Management
Classification: Tools
Component: RSE (show other bugs)
Version: 3.0   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: 3.3 M7   Edit
Assignee: David McKnight CLA
QA Contact: Martin Oberhuber CLA
URL:
Whiteboard:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2008-01-18 10:18 EST by Kevin Doyle CLA
Modified: 2011-05-02 11:40 EDT (History)
1 user (show)

See Also:

Attachments
patch to avoid unnecessary duplicate queries (4.06 KB, patch)
2011-03-18 16:57 EDT, David McKnight CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Doyle CLA 2008-01-18 10:18:50 EST 
With the new file permission changes it's easily noticeable that duplicate queries are performed when refreshing.

Steps to Reproduce:
1. Create a dstore connection.
2. Expand your My Home Filter.
3. Select Show In Table on the My Home filter.
4. Refresh the table by clicking on the Refresh button on the toolbar.
--> You will see it populate the permissions, group, and owner columns.  Once it is done wait 1-10 seconds.  You will see it start to repopulate those column in the table.  If you have the progress view open you will see the second set of jobs.  If the My Home filter in the Remote Systems View is not expanded though you will only get one set of jobs.

-----------Enter bugs above this line-----------
TM 3.0M4 Testing
installation : eclipse-SDK-3.4M3
RSE install  : RSE 3.0M4
java.runtime : Sun 1.5.0_11-b03
os.name:     : Windows XP, Service Pack 2
------------------------------------------------
Comment 1 David McKnight CLA 2008-07-09 15:24:01 EDT 
Kevin, do you still see this one?
Comment 2 Kevin Doyle CLA 2008-07-11 00:07:15 EDT 
Yes, but now it's really quick.  First I see Pending... then the value then Pending.. again
Comment 3 David McKnight CLA 2008-10-29 16:11:34 EDT 
(In reply to comment #2)
> Yes, but now it's really quick.  First I see Pending... then the value then
> Pending.. again
> 

Kevin, does this still happen for you.  When I tried to reproduce it, I only saw "Pending..." once for each refresh.
Comment 4 Kevin Doyle CLA 2008-11-04 11:27:07 EST 
I don't see it all the time now, but will usually every other time when refreshing from the table view.
Comment 5 David McKnight CLA 2010-05-27 09:09:53 EDT 
Bulk move to 3.2.1 target milestone.
Comment 6 David McKnight CLA 2010-08-20 09:36:35 EDT 
Moving some bug milestones from 3.2.1 to 3.2.2.
Comment 7 David McKnight CLA 2010-12-22 09:14:28 EST 
Bulk moving 3.2.x bugs to 3.3
Comment 8 David McKnight CLA 2011-03-18 16:57:31 EDT 
Created attachment 191555 [details]
patch to avoid unnecessary duplicate queries

I don't think this addresses all cases but, for most refreshes in the table, the patch should result in a single query.
Comment 9 David McKnight CLA 2011-03-18 16:59:43 EDT 
I've committed the patch to cvs.  Please reopen if you still see issues.