Performance Problem with Gift Certificate Panel

[pinkchalkstudio]

I'm experiencing a growing performance issue on the Mail Gift Certificate panel. When I initially enter the panel it's now taking 2 1/2 minutes to bring up the entry fields.

My guess is it's related to the customer list of e-mail addresses. If I'm issuing multiple gift certificates at the same time then the subsequent refresh of the panel appears to cache the data and it comes up quickly.

Besides it being a pain to sit and wait several minutes for a panel to come up I'm concerned about future growth of my customer base and the ability to use this functionality (which I utilize a lot). I'm at 3,400 customers right now and can see that number increasing significantly over time.

As a related observation: I also have a performance issue when using the Export Email Addresses mod. It appears this may be doing the same bit of logic to create that big list of customer e-mail addresses.

I'm not certain of how to debug this type of thing for better analysis, any assistance would be appreciated!

Thank you, Kathy

[Ajeh]

The waiting on the download from the pull down for the email addresses is what makes this so slow with a large number of customers ...

If you edit:
/admin/gv_mail.php

and around line 362 change:

              <tr>
                <td class="main"><?php echo TEXT_CUSTOMER; ?></td>
                <td><?php echo zen_draw_pull_down_menu('customers_email_address', $customers, $_GET['customer']);?></td>
              </tr>

to read:

<?php if (false) { ?>
              <tr>
                <td class="main"><?php echo TEXT_CUSTOMER; ?></td>
                <td><?php echo zen_draw_pull_down_menu('customers_email_address', $customers, $_GET['customer']);?></td>
              </tr>
<?php } ?>

It should speed things up for you as now the dropdown is not trying to draw the 1000s of lines needed for the customers' emails and you should be able to type in an email address for it to send ...

Be sure to test this out ...

[pinkchalkstudio]

Thanks Ajeh Worked like a charm. I no longer have to fear sending out gift certificates!

[Ajeh]

Only if you typo the email address ...

Thanks for the update that this works for you ...

Oh ... one other change ... I missed ...

Just above that code you will see:

<?php
     $customers = get_audiences_list('email');
?>

Change that to:

<?php
    // $customers = get_audiences_list('email');
?>

Makes it even faster when you don't first build the list that you are not going to display ...

[pinkchalkstudio]

Added that in and it still works :)

I send the majority of my gift certificates out as promotional tools to people that aren't customers yet. Even when I send to customers the list was so big it wasn't very helpful.

Thank you!

Kathy

[Ajeh]

Glad you asked this question as I have a client with 94,979 customers and while I had long, long ago turned off the one part ... I forgot that last part I gave you ...

I peeked in there to see that I had done that change for him and yes it was done ... but not "as fast" as I wanted it ... then I saw I forgot to comment that last piece of code ...

Much much better now ...

Granted he is on a fast server so wasn't suffering horribly but it was still a 2-4 seconds more than it needed to be and now the page pops open nicely ...