We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Performance issues in OpenClinica 3.1.2

Hi all,
We are having some performance problems in 3.1.2 which was not the
case in earlier versions.
When data is entered, it takes ± 5 seconds to open the window and
another 5 seconds to save the data.
This was not the case before.
Anyone else experiencing this?
Thanks, Cuneyt.
-- Cuneyt Parlayan Datamanager Department of Pathology VU University Medical Center Amsterdam - The Netherlands
«134

Comments

  • mx8866mx8866 Posts: 109
    We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is slower to load the page than OC3.1.1
    Thanks
    May
    -----Original Message-----
    Sent: Monday, January 30, 2012 3:30 AM
    To: [email protected]
    Subject: [Users] Performance issues in OpenClinica 3.1.2
    Hi all,
    We are having some performance problems in 3.1.2 which was not the case in earlier versions.
    When data is entered, it takes ± 5 seconds to open the window and another 5 seconds to save the data.
    This was not the case before.
    Anyone else experiencing this?
    Thanks, Cuneyt.
    --
    Cuneyt Parlayan
    Datamanager
    Department of Pathology
    VU University Medical Center
    Amsterdam - The Netherlands
  • kristiakkristiak Posts: 1,323 ✭✭✭
    A trick that I been very successful with is to put the database on a SSD
    drive. What took up to 10 seconds now takes less than 1 second using 3.1.2
    Regards
    Krister
    -----Original Message-----
    On Behalf Of Xi, Xuemei
    Sent: 30 January 2012 14:29
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is slower
    to load the page than OC3.1.1
    Thanks
    May
    -----Original Message-----
    On Behalf Of Cuneyt Parlayan
    Sent: Monday, January 30, 2012 3:30 AM
    To: [email protected]
    Subject: [Users] Performance issues in OpenClinica 3.1.2
    Hi all,
    We are having some performance problems in 3.1.2 which was not the case in
    earlier versions.
    When data is entered, it takes ± 5 seconds to open the window and another
    5 seconds to save the data.
    This was not the case before.
    Anyone else experiencing this?
    Thanks, Cuneyt.
    --
    Cuneyt Parlayan
    Datamanager
    Department of Pathology
    VU University Medical Center
    Amsterdam - The Netherlands
  • Dear Krister,
    Thanks for mentioning that, I mentioned SSDs (solid state disks) on the Performance page in the OpenClinica Wikibook, thinking they would dramatically speed up OpenClinica, and your story provides further confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid disks that use SSDs):
    http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    "Disk requirements: Whilst the space taken up for the application and PostgreSQL are relatively small (Oracle's requirements will vary), faster disks, including SSDs (solid state disks) and high speed hard disks, will speed up the response times of PostgreSQL or Oracle. For example, OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses Fusion-io's hybrid disk technology to improve database performance. Additionally, one user reported faster performance on the OpenClinica user list."
    If others are thinking about using SSDs, they should be aware that, just like regular hard drives, SSDs do fail (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html), and should be backed up regularly and use RAID where appropriate (as with regular hard drives).
    May and Cuneyt, were your versions of OpenClinica upgrades, or fresh installs? There was a fix for 404's and some consolidation of CSS that should have sped up 3.1.2 a little (mentioned on http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    Yours,
    Michael
    -----Original Message-----
    Sent: 30 January 2012 13:40
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    A trick that I been very successful with is to put the database on a SSD drive. What took up to 10 seconds now takes less than 1 second using 3.1.2
    Regards
    Krister
    -----Original Message-----
    On Behalf Of Xi, Xuemei
    Sent: 30 January 2012 14:29
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is slower to load the page than OC3.1.1
    Thanks
    May
    -----Original Message-----
    On Behalf Of Cuneyt Parlayan
    Sent: Monday, January 30, 2012 3:30 AM
    To: [email protected]
    Subject: [Users] Performance issues in OpenClinica 3.1.2
    Hi all,
    We are having some performance problems in 3.1.2 which was not the case in earlier versions.
    When data is entered, it takes ± 5 seconds to open the window and another
    5 seconds to save the data.
    This was not the case before.
    Anyone else experiencing this?
    Thanks, Cuneyt.
    --
    Cuneyt Parlayan
    Datamanager
    Department of Pathology
    VU University Medical Center
    Amsterdam - The Netherlands
  • I would suggest looking more closely at the software than the hardware. Throwing fast hardware at the problem is a workaround, but not the solution. Typically an eCrf page submit or retrieval only effects a very small volume of data. A single subjects data may only be 5k. Waiting to read this off disks following disk index reads will always be slow in comparison to an in memory operation. Running sequential rules demands pre SQL optimisation.
    Doug Bain
    On 30 Jan 2012, at 16:28, "Michael Bluett" wrote:
    > > Dear Krister,
    > >
    > > Thanks for mentioning that, I mentioned SSDs (solid state disks) on the Performance page in the OpenClinica Wikibook, thinking they would dramatically speed up OpenClinica, and your story provides further confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid disks that use SSDs):
    > >
    > > http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    > > "Disk requirements: Whilst the space taken up for the application and PostgreSQL are relatively small (Oracle's requirements will vary), faster disks, including SSDs (solid state disks) and high speed hard disks, will speed up the response times of PostgreSQL or Oracle. For example, OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses Fusion-io's hybrid disk technology to improve database performance. Additionally, one user reported faster performance on the OpenClinica user list."
    > >
    > > If others are thinking about using SSDs, they should be aware that, just like regular hard drives, SSDs do fail (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html), and should be backed up regularly and use RAID where appropriate (as with regular hard drives).
    > >
    > > May and Cuneyt, were your versions of OpenClinica upgrades, or fresh installs? There was a fix for 404's and some consolidation of CSS that should have sped up 3.1.2 a little (mentioned on http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    > >
    > > Yours,
    > >
    > > Michael
    > > -----Original Message-----
    > >
    > > Sent: 30 January 2012 13:40
    > > To: [email protected]
    > > Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > A trick that I been very successful with is to put the database on a SSD drive. What took up to 10 seconds now takes less than 1 second using 3.1.2
    > >
    > > Regards
    > >
    > > Krister
    > >
    > > -----Original Message-----
    > >
    > > On Behalf Of Xi, Xuemei
    > > Sent: 30 January 2012 14:29
    > > To: [email protected]
    > > Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is slower to load the page than OC3.1.1
    > >
    > > Thanks
    > > May
    > >
    > > -----Original Message-----
    > >
    > > On Behalf Of Cuneyt Parlayan
    > > Sent: Monday, January 30, 2012 3:30 AM
    > > To: [email protected]
    > > Subject: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > Hi all,
    > >
    > > We are having some performance problems in 3.1.2 which was not the case in earlier versions.
    > >
    > > When data is entered, it takes ± 5 seconds to open the window and another
    > > 5 seconds to save the data.
    > > This was not the case before.
    > > Anyone else experiencing this?
    > > Thanks, Cuneyt.
    > >
    > > --
    > > Cuneyt Parlayan
    > >
    > > Datamanager
    > > Department of Pathology
    > > VU University Medical Center
    > > Amsterdam - The Netherlands
    > >
  • kristiakkristiak Posts: 1,323 ✭✭✭
    Dear Michael,
    I agree 100%. My installs are fresh 3.1.2 installs in a RAID configuration.
    It also compensates for the SSL low performance.
    Regards
    Krister
    -----Original Message-----
    On Behalf Of Michael Bluett
    Sent: 30 January 2012 17:20
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    Dear Krister,
    Thanks for mentioning that, I mentioned SSDs (solid state disks) on the
    Performance page in the OpenClinica Wikibook, thinking they would
    dramatically speed up OpenClinica, and your story provides further
    confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid disks
    that use SSDs):
    http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    "Disk requirements: Whilst the space taken up for the application and
    PostgreSQL are relatively small (Oracle's requirements will vary), faster
    disks, including SSDs (solid state disks) and high speed hard disks, will
    speed up the response times of PostgreSQL or Oracle. For example,
    OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses
    Fusion-io's hybrid disk technology to improve database performance.
    Additionally, one user reported faster performance on the OpenClinica user
    list."
    If others are thinking about using SSDs, they should be aware that, just
    like regular hard drives, SSDs do fail
    (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html)
    , and should be backed up regularly and use RAID where appropriate (as with
    regular hard drives).
    May and Cuneyt, were your versions of OpenClinica upgrades, or fresh
    installs? There was a fix for 404's and some consolidation of CSS that
    should have sped up 3.1.2 a little (mentioned on
    http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    Yours,
    Michael
    -----Original Message-----
    On Behalf Of Krister Kristianson
    Sent: 30 January 2012 13:40
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    A trick that I been very successful with is to put the database on a SSD
    drive. What took up to 10 seconds now takes less than 1 second using 3.1.2
    Regards
    Krister
    -----Original Message-----
    On Behalf Of Xi, Xuemei
    Sent: 30 January 2012 14:29
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is slower
    to load the page than OC3.1.1
    Thanks
    May
    -----Original Message-----
    On Behalf Of Cuneyt Parlayan
    Sent: Monday, January 30, 2012 3:30 AM
    To: [email protected]
    Subject: [Users] Performance issues in OpenClinica 3.1.2
    Hi all,
    We are having some performance problems in 3.1.2 which was not the case in
    earlier versions.
    When data is entered, it takes ± 5 seconds to open the window and another
    5 seconds to save the data.
    This was not the case before.
    Anyone else experiencing this?
    Thanks, Cuneyt.
    --
    Cuneyt Parlayan
    Datamanager
    Department of Pathology
    VU University Medical Center
    Amsterdam - The Netherlands
  • kristiakkristiak Posts: 1,323 ✭✭✭
    Hi Doug,
    Although I agree with you I do not have possibilities to do anything
    software wise!
    Regards
    Krister
    -----Original Message-----
    On Behalf Of Douglas Bain
    Sent: 30 January 2012 17:54
    To: [email protected]
    Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    I would suggest looking more closely at the software than the hardware.
    Throwing fast hardware at the problem is a workaround, but not the solution.
    Typically an eCrf page submit or retrieval only effects a very small volume
    of data. A single subjects data may only be 5k. Waiting to read this off
    disks following disk index reads will always be slow in comparison to an in
    memory operation. Running sequential rules demands pre SQL optimisation.
    Doug Bain
    On 30 Jan 2012, at 16:28, "Michael Bluett" wrote:
    > > Dear Krister,
    > >
    > > Thanks for mentioning that, I mentioned SSDs (solid state disks) on the
    Performance page in the OpenClinica Wikibook, thinking they would
    dramatically speed up OpenClinica, and your story provides further
    confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid disks
    that use SSDs):
    > >
    > > http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    > > "Disk requirements: Whilst the space taken up for the application and
    PostgreSQL are relatively small (Oracle's requirements will vary), faster
    disks, including SSDs (solid state disks) and high speed hard disks, will
    speed up the response times of PostgreSQL or Oracle. For example,
    OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses
    Fusion-io's hybrid disk technology to improve database performance.
    Additionally, one user reported faster performance on the OpenClinica user
    list."
    > >
    > > If others are thinking about using SSDs, they should be aware that, just
    like regular hard drives, SSDs do fail
    (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html)
    , and should be backed up regularly and use RAID where appropriate (as with
    regular hard drives).
    > >
    > > May and Cuneyt, were your versions of OpenClinica upgrades, or fresh
    installs? There was a fix for 404's and some consolidation of CSS that
    should have sped up 3.1.2 a little (mentioned on
    http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    > >
    > > Yours,
    > >
    > > Michael
    > > -----Original Message-----
    > >
    On Behalf Of Krister Kristianson
    > > Sent: 30 January 2012 13:40
    > > To: [email protected]
    > > Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > A trick that I been very successful with is to put the database on a SSD
    drive. What took up to 10 seconds now takes less than 1 second using 3.1.2
    > >
    > > Regards
    > >
    > > Krister
    > >
    > > -----Original Message-----
    > >
    > > On Behalf Of Xi, Xuemei
    > > Sent: 30 January 2012 14:29
    > > To: [email protected]
    > > Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is
    slower to load the page than OC3.1.1
    > >
    > > Thanks
    > > May
    > >
    > > -----Original Message-----
    > >
    > > On Behalf Of Cuneyt Parlayan
    > > Sent: Monday, January 30, 2012 3:30 AM
    > > To: [email protected]
    > > Subject: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > Hi all,
    > >
    > > We are having some performance problems in 3.1.2 which was not the case in
    earlier versions.
    > >
    > > When data is entered, it takes ± 5 seconds to open the window and
    another
    > > 5 seconds to save the data.
    > > This was not the case before.
    > > Anyone else experiencing this?
    > > Thanks, Cuneyt.
    > >
    > > --
    > > Cuneyt Parlayan
    > >
    > > Datamanager
    > > Department of Pathology
    > > VU University Medical Center
    > > Amsterdam - The Netherlands
    > >
  • parlayanparlayan Posts: 139
    Hi Michael,
    We have upgraded from 3.1 to 3.1.2 conform OC upgrade manual. Thanks
    for the information.
    I agree with Doug that this is a software issue. It looks like it is
    introduced in 3.1.2.
    I would also like to know what the OC project managers (Tom, Ben)
    think about this and what is their suggestion; that is, waiting for a
    software patch or upgrading the hardware to SSD's?
    Thanks, Cuneyt.
    On Mon, Jan 30, 2012 at 6:13 PM, Krister Kristianson
    wrote:
    > > Hi Doug,
    > >
    > > Although I agree with you I do not have possibilities to do anything
    > > software wise!
    > >
    > > Regards
    > >
    > > Krister
    > >
    > > -----Original Message-----
    > >
    > > On Behalf Of Douglas Bain
    > > Sent: 30 January 2012 17:54
    > > To: [email protected]
    > > Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    > >
    > > I would suggest looking more closely at the software than the hardware.
    > > Throwing fast hardware at the problem is a workaround, but not the solution.
    > > Typically an eCrf page submit or retrieval only effects a very small volume
    > > of data. A single subjects data may only be 5k. Waiting to read this off
    > > disks following disk index reads will always be slow in comparison to an in
    > > memory operation. Running sequential rules demands pre SQL optimisation.
    > >
    > > Doug Bain
    > >
    > >
    > > On 30 Jan 2012, at 16:28, "Michael Bluett" wrote:
    > >
    >> >> Dear Krister,
    >> >>
    >> >> Thanks for mentioning that, I mentioned SSDs (solid state disks) on the
    > > Performance page in the OpenClinica Wikibook, thinking they would
    > > dramatically speed up OpenClinica, and your story provides further
    > > confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid disks
    > > that use SSDs):
    >> >>
    >> >> http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    >> >> "Disk requirements: Whilst the space taken up for the application and
    > > PostgreSQL are relatively small (Oracle's requirements will vary), faster
    > > disks, including SSDs (solid state disks) and high speed hard disks, will
    > > speed up the response times of PostgreSQL or Oracle. For example,
    > > OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses
    > > Fusion-io's hybrid disk technology to improve database performance.
    > > Additionally, one user reported faster performance on the OpenClinica user
    > > list."
    >> >>
    >> >> If others are thinking about using SSDs, they should be aware that, just
    > > like regular hard drives, SSDs do fail
    > > (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html)
    > > , and should be backed up regularly and use RAID where appropriate (as with
    > > regular hard drives).
    >> >>
    >> >> May and Cuneyt, were your versions of OpenClinica upgrades, or fresh
    > > installs? There was a fix for 404's and some consolidation of CSS that
    > > should have sped up 3.1.2 a little (mentioned on
    > > http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    >> >>
    >> >> Yours,
    >> >>
    >> >> Michael
    >> >> -----Original Message-----
    >> >>
    > > On Behalf Of Krister Kristianson
    >> >> Sent: 30 January 2012 13:40
    >> >> To: [email protected]
    >> >> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >> >>
    >> >> A trick that I been very successful with is to put the database on a SSD
    > > drive. What took up to 10 seconds now takes less than 1 second using 3.1.2
    >> >>
    >> >> Regards
    >> >>
    >> >> Krister
    >> >>
    >> >> -----Original Message-----
    >> >>
    >> >> On Behalf Of Xi, Xuemei
    >> >> Sent: 30 January 2012 14:29
    >> >> To: [email protected]
    >> >> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >> >>
    >> >> We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is
    > > slower to load the page than OC3.1.1
    >> >>
    >> >> Thanks
    >> >> May
    >> >>
    >> >> -----Original Message-----
    >> >>
    >> >> On Behalf Of Cuneyt Parlayan
    >> >> Sent: Monday, January 30, 2012 3:30 AM
    >> >> To: [email protected]
    >> >> Subject: [Users] Performance issues in OpenClinica 3.1.2
    >> >>
    >> >> Hi all,
    >> >>
    >> >> We are having some performance problems in 3.1.2 which was not the case in
    > > earlier versions.
    >> >>
    >> >> When data is entered, it takes ± 5 seconds to open the window and
    > > another
    >> >> 5 seconds to save the data.
    >> >> This was not the case before.
    >> >> Anyone else experiencing this?
    >> >> Thanks, Cuneyt.
    >> >>
    >> >> --
    >> >> Cuneyt Parlayan
    >> >>
    >> >> Datamanager
    >> >> Department of Pathology
    >> >> VU University Medical Center
    >> >> Amsterdam - The Netherlands
    >> >>
  • gbraukgbrauk Posts: 8
    Hi,
    we have made the same experiences. Before we updated to the 3.1.x version
    window opening for data entry and saving was much faster.
    Kind regards, Gisela
    Gisela Braukmüller
    Data Manager
    GCP-Service International Ltd. & Co. KG
    -----Ursprüngliche Nachricht-----
    Von: [email protected] [mailto:[email protected]] Im
    Auftrag von Cuneyt Parlayan
    Gesendet: Montag, 30. Januar 2012 10:30
    An: [email protected]
    Betreff: [Users] Performance issues in OpenClinica 3.1.2
    Hi all,
    We are having some performance problems in 3.1.2 which was not the
    case in earlier versions.
    When data is entered, it takes ± 5 seconds to open the window and
    another 5 seconds to save the data.
    This was not the case before.
    Anyone else experiencing this?
    Thanks, Cuneyt.
    -- Cuneyt Parlayan Datamanager Department of Pathology VU University Medical Center Amsterdam - The Netherlands
  • GerbenRienkGerbenRienk Posts: 803 ✭✭✭
    Hello Cuneyt,
    Just to get the picture clearer:
    - did you run the performance scripts that created the extra indexes
    successfully?
    - how often do you do a REINDEX?
    - did you finetune your memorysettings for postgres?
    Kind regards,
    Gerben Rienk
    > > Hi Michael,
    > > We have upgraded from 3.1 to 3.1.2 conform OC upgrade manual. Thanks
    > > for the information.
    > > I agree with Doug that this is a software issue. It looks like it is
    > > introduced in 3.1.2.
    > > I would also like to know what the OC project managers (Tom, Ben)
    > > think about this and what is their suggestion; that is, waiting for a
    > > software patch or upgrading the hardware to SSD's?
    > > Thanks, Cuneyt.
    > >
    > > On Mon, Jan 30, 2012 at 6:13 PM, Krister Kristianson
    > > wrote:
    >> >> Hi Doug,
    >> >>
    >> >> Although I agree with you I do not have possibilities to do anything
    >> >> software wise!
    >> >>
    >> >> Regards
    >> >>
    >> >> Krister
    >> >>
    >> >> -----Original Message-----
    >> >>
    >> >> [mailto:[email protected]]
    >> >> On Behalf Of Douglas Bain
    >> >> Sent: 30 January 2012 17:54
    >> >> To: [email protected]
    >> >> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >> >>
    >> >> I would suggest looking more closely at the software than the hardware.
    >> >> Throwing fast hardware at the problem is a workaround, but not the
    >> >> solution.
    >> >> Typically an eCrf page submit or retrieval only effects a very small
    >> >> volume
    >> >> of data. A single subjects data may only be 5k. Waiting to read this off
    >> >> disks following disk index reads will always be slow in comparison to an
    >> >> in
    >> >> memory operation. Running sequential rules demands pre SQL
    >> >> optimisation.
    >> >>
    >> >> Doug Bain
    >> >>
    >> >>
    >> >> On 30 Jan 2012, at 16:28, "Michael Bluett"
    >> >> wrote:
    >> >>
    >>> >>> Dear Krister,
    >>> >>>
    >>> >>> Thanks for mentioning that, I mentioned SSDs (solid state disks) on the
    >> >> Performance page in the OpenClinica Wikibook, thinking they would
    >> >> dramatically speed up OpenClinica, and your story provides further
    >> >> confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid
    >> >> disks
    >> >> that use SSDs):
    >>> >>>
    >>> >>> http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    >>> >>> "Disk requirements: Whilst the space taken up for the application and
    >> >> PostgreSQL are relatively small (Oracle's requirements will vary),
    >> >> faster
    >> >> disks, including SSDs (solid state disks) and high speed hard disks,
    >> >> will
    >> >> speed up the response times of PostgreSQL or Oracle. For example,
    >> >> OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses
    >> >> Fusion-io's hybrid disk technology to improve database performance.
    >> >> Additionally, one user reported faster performance on the OpenClinica
    >> >> user
    >> >> list."
    >>> >>>
    >>> >>> If others are thinking about using SSDs, they should be aware that,
    >>> >>> just
    >> >> like regular hard drives, SSDs do fail
    >> >> (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html)
    >> >> , and should be backed up regularly and use RAID where appropriate (as
    >> >> with
    >> >> regular hard drives).
    >>> >>>
    >>> >>> May and Cuneyt, were your versions of OpenClinica upgrades, or fresh
    >> >> installs? There was a fix for 404's and some consolidation of CSS that
    >> >> should have sped up 3.1.2 a little (mentioned on
    >> >> http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    >>> >>>
    >>> >>> Yours,
    >>> >>>
    >>> >>> Michael
    >>> >>> -----Original Message-----
    >>> >>>
    >>> >>> [mailto:[email protected]]
    >> >> On Behalf Of Krister Kristianson
    >>> >>> Sent: 30 January 2012 13:40
    >>> >>> To: [email protected]
    >>> >>> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >>> >>>
    >>> >>> A trick that I been very successful with is to put the database on a
    >>> >>> SSD
    >> >> drive. What took up to 10 seconds now takes less than 1 second using
    >> >> 3.1.2
    >>> >>>
    >>> >>> Regards
    >>> >>>
    >>> >>> Krister
    >>> >>>
    >>> >>> -----Original Message-----
    >>> >>>
    >>> >>> [mailto:[email protected]]
    >>> >>> On Behalf Of Xi, Xuemei
    >>> >>> Sent: 30 January 2012 14:29
    >>> >>> To: [email protected]
    >>> >>> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >>> >>>
    >>> >>> We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is
    >> >> slower to load the page than OC3.1.1
    >>> >>>
    >>> >>> Thanks
    >>> >>> May
    >>> >>>
    >>> >>> -----Original Message-----
    >>> >>>
    >>> >>> [mailto:[email protected]]
    >>> >>> On Behalf Of Cuneyt Parlayan
    >>> >>> Sent: Monday, January 30, 2012 3:30 AM
    >>> >>> To: [email protected]
    >>> >>> Subject: [Users] Performance issues in OpenClinica 3.1.2
    >>> >>>
    >>> >>> Hi all,
    >>> >>>
    >>> >>> We are having some performance problems in 3.1.2 which was not the case
    >>> >>> in
    >> >> earlier versions.
    >>> >>>
    >>> >>> When data is entered, it takes ± 5 seconds to open the window and
    >> >> another
    >>> >>> 5 seconds to save the data.
    >>> >>> This was not the case before.
    >>> >>> Anyone else experiencing this?
    >>> >>> Thanks, Cuneyt.
    >>> >>>
    >>> >>> --
    >>> >>> Cuneyt Parlayan
    >>> >>>
    >>> >>> Datamanager
    >>> >>> Department of Pathology
    >>> >>> VU University Medical Center
    >>> >>> Amsterdam - The Netherlands
    >>> >>>
  • parlayanparlayan Posts: 139
    Hi Gerben,
    Thanks for your input.
    My postgres uses the defaults (I didn't change anything and followed
    the OC installation guide).
    During the upgrade I also followed the instructions provided by OC
    upgrade manual.
    Where are the "performance scripts"?
    How do you "REINDEX"?
    How do you change memory settings for postgress?
    Thanks,
    Cuneyt.
    PS: This is only happening in version 3.1.2. So it is not something
    that gradually happened, thats why I didn't suspect the database
    indexes.
    On Tue, Jan 31, 2012 at 11:57 AM, Gerben Rienk wrote:
    > > Hello Cuneyt,
    > >
    > > Just to get the picture clearer:
    > > - did you run the performance scripts that created the extra indexes
    > > successfully?
    > > - how often do you do a REINDEX?
    > > - did you finetune your memorysettings for postgres?
    > >
    > > Kind regards,
    > >
    > > Gerben Rienk
    > >
    >> >> Hi Michael,
    >> >> We have upgraded from 3.1 to 3.1.2 conform OC upgrade manual. Thanks
    >> >> for the information.
    >> >> I agree with Doug that this is a software issue. It looks like it is
    >> >> introduced in 3.1.2.
    >> >> I would also like to know what the OC project managers (Tom, Ben)
    >> >> think about this and what is their suggestion; that is, waiting for a
    >> >> software patch or upgrading the hardware to SSD's?
    >> >> Thanks, Cuneyt.
    >> >>
    >> >> On Mon, Jan 30, 2012 at 6:13 PM, Krister Kristianson
    >> >> wrote:
    >>> >>> Hi Doug,
    >>> >>>
    >>> >>> Although I agree with you I do not have possibilities to do anything
    >>> >>> software wise!
    >>> >>>
    >>> >>> Regards
    >>> >>>
    >>> >>> Krister
    >>> >>>
    >>> >>> -----Original Message-----
    >>> >>>
    >>> >>> [mailto:[email protected]]
    >>> >>> On Behalf Of Douglas Bain
    >>> >>> Sent: 30 January 2012 17:54
    >>> >>> To: [email protected]
    >>> >>> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >>> >>>
    >>> >>> I would suggest looking more closely at the software than the hardware.
    >>> >>> Throwing fast hardware at the problem is a workaround, but not the
    >>> >>> solution.
    >>> >>> Typically an eCrf page submit or retrieval only effects a very small
    >>> >>> volume
    >>> >>> of data. A single subjects data may only be 5k. Waiting to read this off
    >>> >>> disks following disk index reads will always be slow in comparison to an
    >>> >>> in
    >>> >>> memory operation. Running sequential rules demands pre SQL
    >>> >>> optimisation.
    >>> >>>
    >>> >>> Doug Bain
    >>> >>>
    >>> >>>
    >>> >>> On 30 Jan 2012, at 16:28, "Michael Bluett"
    >>> >>> wrote:
    >>> >>>
    >>>> >>>> Dear Krister,
    >>>> >>>>
    >>>> >>>> Thanks for mentioning that, I mentioned SSDs (solid state disks) on the
    >>> >>> Performance page in the OpenClinica Wikibook, thinking they would
    >>> >>> dramatically speed up OpenClinica, and your story provides further
    >>> >>> confirmation of it (OpenClinica's Optimized(tm) Hosting uses hybrid
    >>> >>> disks
    >>> >>> that use SSDs):
    >>>> >>>>
    >>>> >>>> http://en.wikibooks.org/wiki/OpenClinica_User_Manual/Performance
    >>>> >>>> "Disk requirements: Whilst the space taken up for the application and
    >>> >>> PostgreSQL are relatively small (Oracle's requirements will vary),
    >>> >>> faster
    >>> >>> disks, including SSDs (solid state disks) and high speed hard disks,
    >>> >>> will
    >>> >>> speed up the response times of PostgreSQL or Oracle. For example,
    >>> >>> OpenClinica Optimized(tm) Hosting (Clinical Trials in the Cloud) uses
    >>> >>> Fusion-io's hybrid disk technology to improve database performance.
    >>> >>> Additionally, one user reported faster performance on the OpenClinica
    >>> >>> user
    >>> >>> list."
    >>>> >>>>
    >>>> >>>> If others are thinking about using SSDs, they should be aware that,
    >>>> >>>> just
    >>> >>> like regular hard drives, SSDs do fail
    >>> >>> (http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html)
    >>> >>> , and should be backed up regularly and use RAID where appropriate (as
    >>> >>> with
    >>> >>> regular hard drives).
    >>>> >>>>
    >>>> >>>> May and Cuneyt, were your versions of OpenClinica upgrades, or fresh
    >>> >>> installs? There was a fix for 404's and some consolidation of CSS that
    >>> >>> should have sped up 3.1.2 a little (mentioned on
    >>> >>> http://en.wikibooks.org/wiki/OpenClinica_User_Manual/PageAnalysis).
    >>>> >>>>
    >>>> >>>> Yours,
    >>>> >>>>
    >>>> >>>> Michael
    >>>> >>>> -----Original Message-----
    >>>> >>>>
    >>>> >>>> [mailto:[email protected]]
    >>> >>> On Behalf Of Krister Kristianson
    >>>> >>>> Sent: 30 January 2012 13:40
    >>>> >>>> To: [email protected]
    >>>> >>>> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >>>> >>>>
    >>>> >>>> A trick that I been very successful with is to put the database on a
    >>>> >>>> SSD
    >>> >>> drive. What took up to 10 seconds now takes less than 1 second using
    >>> >>> 3.1.2
    >>>> >>>>
    >>>> >>>> Regards
    >>>> >>>>
    >>>> >>>> Krister
    >>>> >>>>
    >>>> >>>> -----Original Message-----
    >>>> >>>>
    >>>> >>>> [mailto:[email protected]]
    >>>> >>>> On Behalf Of Xi, Xuemei
    >>>> >>>> Sent: 30 January 2012 14:29
    >>>> >>>> To: [email protected]
    >>>> >>>> Subject: Re: [Users] Performance issues in OpenClinica 3.1.2
    >>>> >>>>
    >>>> >>>> We have OC3.1.1 and OC3.1.2 instances. We experience that OC3.1.2 is
    >>> >>> slower to load the page than OC3.1.1
    >>>> >>>>
    >>>> >>>> Thanks
    >>>> >>>> May
    >>>> >>>>
    >>>> >>>> -----Original Message-----
    >>>> >>>>
    >>>> >>>> [mailto:[email protected]]
    >>>> >>>> On Behalf Of Cuneyt Parlayan
    >>>> >>>> Sent: Monday, January 30, 2012 3:30 AM
    >>>> >>>> To: [email protected]
    >>>> >>>> Subject: [Users] Performance issues in OpenClinica 3.1.2
    >>>> >>>>
    >>>> >>>> Hi all,
    >>>> >>>>
    >>>> >>>> We are having some performance problems in 3.1.2 which was not the case
    >>>> >>>> in
    >>> >>> earlier versions.
    >>>> >>>>
    >>>> >>>> When data is entered, it takes ± 5 seconds to open the window and
    >>> >>> another
    >>>> >>>> 5 seconds to save the data.
    >>>> >>>> This was not the case before.
    >>>> >>>> Anyone else experiencing this?
    >>>> >>>> Thanks, Cuneyt.
    >>>> >>>>
    >>>> >>>> --
    >>>> >>>> Cuneyt Parlayan
    >>>> >>>>
    >>>> >>>> Datamanager
    >>>> >>>> Department of Pathology
    >>>> >>>> VU University Medical Center
    >>>> >>>> Amsterdam - The Netherlands
    >>>> >>>>
This discussion has been closed.