Topic
3 replies Latest Post - ‏2013-12-17T23:43:38Z by DonaldN
JK_79
JK_79
2 Posts
ACCEPTED ANSWER

Pinned topic ClearQuest 7.1.2.x - performance limitations with attachments?

‏2013-12-16T12:40:19Z |

Hello,

I use attachments with IBM Rational ClearQuest 7.1.2.9, based on SQL Server 2008 database.

Are there any known limitations which I must consider regarding file count and / or size of data attachments in the ClearQuest database?

 

Cheers,
Jürgen

  • DonaldN
    DonaldN
    222 Posts
    ACCEPTED ANSWER

    Re: ClearQuest 7.1.2.x - performance limitations with attachments?

    ‏2013-12-16T23:30:30Z  in response to JK_79

    The limitation is with the back end database - in this case, SQL Server 2008. The maximum size of a column is 2^31-1 (2GB).

    http://www-01.ibm.com/support/docview.wss?uid=swg21128134

    http://technet.microsoft.com/en-us/library/ms143432%28v=sql.100%29.aspx

    • JK_79
      JK_79
      2 Posts
      ACCEPTED ANSWER

      Re: ClearQuest 7.1.2.x - performance limitations with attachments?

      ‏2013-12-17T06:34:10Z  in response to DonaldN

      Thanks Donald for this information.

      Do you also know performance issues with ClearQuest, when using Blobs excessivly?
      I would say that the limitation also lies with SQL Server 2008. If the database doesn't exceed the known storage limitations as shown in the technet-Article, I think that I can outrule performance problems while using ClearQuest. But I am not sure about this...

       

      Cheers,

      Jürgen

      • DonaldN
        DonaldN
        222 Posts
        ACCEPTED ANSWER

        Re: ClearQuest 7.1.2.x - performance limitations with attachments?

        ‏2013-12-17T23:43:38Z  in response to JK_79

        I am not aware any performance issues with ClearQuest attachments. Since you use the word "excessively", there is one case that you should be aware of. If you allow the SQL Server data file to expand automatically so as to accommodate the unexpected large BLOBs, the SQL Server can be very slow when the data file is being expanded (of course it depends on how fast your storage system is). Another thing to note is that when a user is downloading a large attachment via the internet (from ClearQuest Web) without knowing the actual attachment size and network speed, he/she may complain that ClearQuest is slow.