[jira] Resolved: (OLIO-54) Increase the size of the database

["William Sobel (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OLIO-54?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

William Sobel resolved OLIO-54.
-------------------------------

    Resolution: Fixed

Fixed in r749436:

Added db/migrate/20090302210151_increase_db_field_sizes.rb

Increased size of main fields in SocialEvent and Comments:

Index: src/org/apache/olio/workload/loader/Comments.java
===================================================================
--- src/org/apache/olio/workload/loader/Comments.java   (revision 751142)
+++ src/org/apache/olio/workload/loader/Comments.java   (revision 751143)
@@ -49,7 +49,7 @@
         ratings = new int[commentCount];
         for (int i = 0; i < users.length; i++) {
             users[i] = r.random(1, ScaleFactors.users);;
-            comments[i] = r.makeCString(250, 500);
+            comments[i] = r.makeCString(250, 1024);
             ratings[i] = r.random(2, 5);
         }
         createdTimestamp = r.makeDateInInterval( //createdtimestamp
===================================================================
--- src/org/apache/olio/workload/loader/SocialEvent.java        (revision 751142)
+++ src/org/apache/olio/workload/loader/SocialEvent.java        (revision 751143)
@@ -51,7 +51,7 @@
         Random r = tr.getRandom();
         StringBuilder buffer = tr.getBuffer();
         fields[0] = RandomUtil.randomText(r, 20, 100); //title
-        fields[1] = RandomUtil.randomText(r, 250, 500); // description
+        fields[1] = RandomUtil.randomText(r, 1024, 4096); // description
         fields[2] = RandomUtil.randomPhone(r, buffer); //phone
         DateFormat dateFormat = tr.getDateFormat(); // eventtimestamp
         String eventDate = dateFormat.format(
@@ -62,7 +62,7 @@
         fields[3] = String.format("%s %02d:%s:00",
                                             eventDate, eventHr, eventMin);
         fields[4] = eventDate; // eventdate
-        fields[5] = RandomUtil.randomText(r, 50, 100); // summary
+        fields[5] = RandomUtil.randomText(r, 500, 1024); // summary
         
         createdTimestamp = r.makeDateInInterval( //createdtimestamp
                 BASE_DATE, -540, 0);



> Increase the size of the database
> ---------------------------------
>
>                 Key: OLIO-54
>                 URL: https://issues.apache.org/jira/browse/OLIO-54
>             Project: Olio
>          Issue Type: Improvement
>          Components: rails-loader
>         Environment: Rails and PHP
>            Reporter: William Sobel
>            Assignee: William Sobel
>
> Increase the size of the database by increasing the size of the comments, social event description and the summary. Gage the scale factor and then extrapolate the db size. We need to scale to > 20 Gb.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.