I have not seen the problem that you are having, but I
can comment on the amount of tickets. My Eventum
installation has tracked almost 23,000 issues. This
is only after 8 months of production use. I have 101
users and 15 departments using it. My SQL database is
almost 5GB in size. we allow 10MB attachments. At
this size, I see no performance issues due to dialy
use, size of database, or amount of tickets.
We are planning, however, to disable the ability for
users to list "All" tickets in the list issues
screen.
One project has 14,000 issues and this may take 5
minutes or longer to load all issues including closed
ones. There is really no reason to list all 14,000
tickets, but given the change a user will do it.
I think the Eventum database design is absolutely
perfect. Hats off to the Eventum team on that one.
Travis
Here are my table stats:
Name Rows Data_length
eventum_columns_to_display 299 11032
eventum_custom_field 29 1484
eventum_custom_field_option 42 1164
eventum_custom_filter 15 1288
eventum_customer_account_manager 0 0
eventum_customer_note 0 0
eventum_email_account 18 1256
eventum_email_draft 6 31628
eventum_email_draft_recipient 14 388
eventum_email_response 3 1272
eventum_faq 1 212
eventum_faq_support_level 0 0
eventum_group 0 0
eventum_history_type 59 1504
eventum_irc_notice 0 0
eventum_issue 22668 20001932
eventum_issue_association 348 3132
eventum_issue_attachment 9680 817444
eventum_issue_attachment_file 14921 1344434184
eventum_issue_checkin 0 0
eventum_issue_custom_field 24363 671932
eventum_issue_history 238906 20266308
eventum_issue_quarantine 0 0
eventum_issue_requirement 0 0
eventum_issue_user 26899 457283
eventum_issue_user_replier 563 13608
eventum_link_filter 0 0
eventum_mail_queue 109486 1342509368
eventum_mail_queue_log 557188 49887856
eventum_news 3 1208
eventum_note 27624 61223180
eventum_phone_support 20 5424
eventum_project 18 2136
eventum_project_category 132 3952
eventum_project_custom_field 30 390
eventum_project_email_response 4 36
eventum_project_field_display 136 2856
eventum_project_group 0 0
eventum_project_link_filter 0 0
eventum_project_news 8 72
eventum_project_phone_category 44 1228
eventum_project_priority 71 1632
eventum_project_release 17 536
eventum_project_round_robin 0 0
eventum_project_status 132 1716
eventum_project_status_date 22 948
eventum_project_user 145 2030
eventum_reminder_action 1 100
eventum_reminder_action_list 0 0
eventum_reminder_action_type 4 176
eventum_reminder_field 8 776
eventum_reminder_history 0 0
eventum_reminder_level 1 64
eventum_reminder_level_condition 1 28
eventum_reminder_operator 8 188
eventum_reminder_priority 1 13
eventum_reminder_requirement 1 22
eventum_reminder_triggered_action 2 18
eventum_resolution 14 452
eventum_round_robin_user 0 0
eventum_search_profile 277 203040
eventum_status 39 1544
eventum_subscription 48563 1935548
eventum_subscription_type 143041 2861060
eventum_support_email 53179 11285096
eventum_support_email_body 53198 1828957916
eventum_time_tracking 19936 1443500
eventum_time_tracking_category 20 656
eventum_user 102 42512
Totals 1352310 4687094328
Travis Pierce
--- "Iovino, Vincent" <viovino taylorbean.com> wrote:
> Just recently we started experiencing a problem when
> updating the Issue
> Overview section in version 1.4. We would get a
> blank screen after the
> priority field when trying to update the Issue
> Overview section. We were
> able to solve the issue by increasing php.ini's
> memory allocation to
> 60MB.
>
> We are in the process of testing version 1.7 and ran
> into the same
> problem. We've been able to solve the problem again
> by increasing php's
> memory allocation to 200MB. This fix is temporary,
> however, as the
> Eventum database grows larger.
>
> Has anyone else run into this problem/issue?
> What is the effective limit, if any, to the number
> of Eventum Issues
> within the Eventum Application.
>
> Thank You,
>
> Vincent Iovino
> Technology Auditor
> Taylor, Bean & Whitaker Mortgage Corporation
> Tel: 352-671-0067
> Fax: 352-690-0567
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
around
http://mail.yahoo.com
--
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe: http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com
|