[Unicode]   Common Locale Data Repository : Bug Tracking Home | Site Map | Search
 
Modify

CLDR Ticket #8731(accepted survey)

Opened 2 years ago

Last modified 16 months ago

See why Priority Items Summary (VettingViewer) 5x slower than on laptop

Reported by: mark Owned by: srl
Component: survey Data Locale:
Phase: dsub Review:
Weeks: Data Xpath:
Xref:

Description

Because the Priority Items Summary hits a lot of the ST, it is a good proxy for overall performance. That is, when it is slow, the other operations are slow and vice versa.

When I run VV.java on my laptop from Eclipse, it takes

  • 131 seconds (2.18 minutes).

When I run Priority Items Summary>Recalculate on a local server, it is nearly as fast:

  • LoadedTime taken: 2.4 minutes

When I run Priority Items Summary>Recalculate on SmokeTest (no other users), it takes way longer:

  • LoadedTime taken: 10.3 minutes

ST is comparable.

I doubt that my laptop is 5x faster than the servers, so this is worth investigating.

Attachments

Change History

comment:1 Changed 2 years ago by srl

Are you using a mysql server? Derby (default) is in-memory, but doesn't scale to multiple user.

comment:2 Changed 20 months ago by mark

  • Status changed from new to accepted
  • Component changed from unknown to survey
  • Priority changed from assess to major
  • Milestone changed from UNSCH to 29
  • Owner changed from anybody to srl
  • Type changed from unknown to survey

comment:3 Changed 20 months ago by fredrik

Another data point: I just ran the priority items summary on the production ST server. It took 14.4 minutes.

comment:4 Changed 16 months ago by srl

  • Milestone changed from 29 to upcoming
View

Add a comment

Modify Ticket

Action
as accepted
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.