Performance and SQL Repository

[stuckerj]

Hello, this is my first post, so I hope I got it in the right place.

EA 5.00.765 (Corporate Edition)
SQL Server 2005

We have set up a SQL repository using SQL 2005, and are connecting EA client to SQL Server over a WAN.  The performance is dismal -- it takes minutes to open a model.  (Testing on a LAN went fine.)  So I am trying to figure out the root of the issue.  We have very good bandwidth on this connection, so it might be latency.

I have opened a SQL Server Profiler window, and see thousands of lines like the following:

Select * from t_attributetag where ElementID=631 and Property='XUML'
Select * from t_attributetag where ElementID=631 and Property='XUML'
Select * from t_attributetag where ElementID=631 and Property='XUML'
Select * from t_attributetag where ElementID=631 and Property='XUML'
Select * from t_attributetag where ElementID=632 and Property='xUML'
Select * from t_attributetag where ElementID=632 and Property='xUML'
Select * from t_attributetag where ElementID=632 and Property='xUML'
Select * from t_attributetag where ElementID=632 and Property='xUML'

The ElementID is the same for four rows, then changes, and so on for hundreds of rows.  Is this getting the exact same data four times?  Is EA waiting for one query to finish before sending the next one, and the design is multiplying latency?  Is there an opportunity to consolidate these queries?  Is there a patch, or does EA 6 handle this better?

Thanks for your help.

'('    Jeff
\