5 messages in com.mysql.lists.eventum-usersRe: commenting out associated issues ...| From | Sent On | Attachments |
|---|---|---|
| Iovino, Vincent | 02 Jan 2007 07:56 | |
| Bryan Alsdorf | 03 Jan 2007 11:33 | |
| Chris Kirkham | 08 Mar 2007 14:57 | |
| Bryan Alsdorf | 12 Mar 2007 01:30 | |
| Chris Kirkham | 13 Mar 2007 16:43 |
| Subject: | Re: commenting out associated issues and expected resolution date |
|---|---|
| From: | Chris Kirkham (mys...@ckirkham.plus.com) |
| Date: | 03/13/2007 04:43:53 PM |
| List: | com.mysql.lists.eventum-users |
Bryan,
Yes, we do have date custom fields. I have actually been doing some testing on Eventum 2 and the issue is no longer there.
Thanks for the response.
Chris
Bryan Alsdorf wrote:
Hi Chris,
Chris Kirkham wrote:
Eventum 1.7.1, Apache 2.0.55, Windows 2003 server, PHP 5, Mysql 5
I have found another reason for our setup slowing to a crawl. We currently have 8 custom fields set up for issues and we use them very regularly. If am advance filter is applied to the list screen, using a custom field the list displays no problem. The slow down comes when you want to view an issue. The issue was taking up to 15 minutes to appear. We currently have about 900 issues.
The offending section was found to be the view.php, lines 120/121, the next/previous issue calculation. I haven't had chance to look at the code yet, thought I'd ask first to see if anyone else has seen/fixed this issue. Simple work around is to clear filters before trying to view issues.
Is one of the custom fields a "date" field? There was a bug reported 2006/10/23. This has been fixed in Eventum 2. Here is the diff:
@@ -2804,6 +2804,10 @@ continue; } $field = Custom_Field::getDetails($fld_id); + if (($field['fld_type'] == 'date') && + ((empty($search_value['Year'])) || (empty($search_value['Month'])) || (empty($search_value['Day'])))) { + continue; + }
if ($field['fld_type'] == 'multiple') { $search_value = Misc::escapeInteger($search_value); @@ -2868,6 +2872,11 @@ continue; } $field = Custom_Field::getDetails($fld_id); + if (($field['fld_type'] == 'date') && + ((empty($search_value['Year'])) || (empty($search_value['Month'])) || (empty($search_value['Day'])))) { + continue; + } + if ($field['fld_type'] == 'multiple') { $search_value = Misc::escapeInteger($search_value); foreach ($search_value as $cfo_id) {
Best Regards, /bryan