Bug 749689 - CS builds take a ridiculously long time against remote DB servers
Summary: CS builds take a ridiculously long time against remote DB servers
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: PressGang CCMS
Classification: Community
Component: CSProcessor
Version: 1.x
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Lee Newson
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-27 22:35 UTC by Joshua Wulf
Modified: 2014-10-19 22:59 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-04 10:51:02 UTC

Attachments (Terms of Use)
Example Content Spec (5.87 KB, text/plain)
2011-10-28 01:21 UTC, Joshua Wulf 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Description Joshua Wulf 2011-10-27 22:35:58 UTC 
When the app server and the database are on different nodes building takes *forever*. A huge amount of data is transferred over the network. Can we optimise this?
Comment 1 Joshua Wulf 2011-10-28 01:21:29 UTC 
Created attachment 530594 [details]
Example Content Spec

Either pushing this content to the csprocessor or building it uses up a massive amount of bandwidth.
Comment 2 Lee Newson 2011-11-01 03:00:15 UTC 
Should have been fixed as of Version 11. The problem was to do with the database sessions.
Comment 3 Joshua Wulf 2011-11-04 10:51:02 UTC 
The only metric I can measure on this at the moment is the server traffic. It's gone from a solid 100MB/s down to 500K-1MB/s.

The build still takes a considerable amount of time, but it's significant in its size.

I don't have the dataset locally to do an A/B test, so we'll close this one for now, and revisit it with some performance testing with each release.
Note You need to log in before you can comment on or make changes to this bug.