05-30-2010 06:18 PM
Quality Center Database Growth Estimates:
Here are some numbers I crunched from our data for another customer. These are averages from my installation and thus may not be typical for all projects or installations. This is for the Database only and does not include File Repository growth.
|If you add to your project between||The database will increase between|
|0 and 500 records||0 MB and 3 MB|
|500 and 1,000 records||3 MB and 5 MB|
|1,000 and 5,000 records||5 MB and 10 MB|
|5,000 and 25,000 records||10 MB and 20 MB|
|25,000 and 50,000 records||20 MB and 30 MB|
|50,000 and 100,000 records||30 MB and 60 MB|
|100,000 and 250,000 records||60 MB and 150 MB|
|250,000 and 500,000 records||150 MB and 300 MB|
|500,000 and 2,500,000 records||300 MB and 1,250 MB|
|greater than 2,500,000 records||greater than 1 GB|
06-29-2010 12:52 PM
Quality Center File Repository Growth
04-24-2014 08:26 AM
I am guessing this is no longer accurate (esp attachements duplicated for different versions/baselines) for QC 11.0 (ALM) with their new Smart Repository functionality. Am I right?
11-07-2014 06:40 AM
Hi, I came across your post and am interested more in the File Repository. However, I'm having difficulty finding information in the documentation about it. Where is the File Repository located exactly?
Previously I thought that it would store the file assets in the database along with the other information for the test resources but it is not there, because it is in this file repo. Any help would be much appreciated.
11-07-2014 08:53 AM
The location of the file repository was specified during the product installation and can also be found by logging in to the Site Admin UI and looking at BASE_REPOSITORY_PATH parameter on the Site Configuration tab.
Prior to version 11 (maybe prior to v10) file assets could be stored in the database. As of version 11 (or maybe it was 10) file assets could no longer be stored in the database and had to be moved to the file repository.
(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
11-07-2014 10:32 AM
Thanks Trudy, I got into Site admin and found the path. I can view (not with FTP as I saw in another post) the files but the lack of structure and detail is not going to working for me, is there a better way perhaps.
Few questions and issues I had if anyone knows.
Is there a best practice to updating a Test Resource Data Table programmatically?
Test Resource Scenario:
• Created New Resource of type Data Table named “test123”
• Uploaded an excel sheet with some rows and columns populated
• I can view this resource with the Resource Viewer
1. How does QC render the excel file to show the worksheet’s values?
a. Does QC parse the excel sheet into an XML file?
b. Is it possible to update the Test Resource Data Table using OTA?
i. Without downloading the file, updating it, and uploading?