Site running fine, admin section extremely slow

My site appears to be working great from the customer perspective, however, for the past week, the admin section is extremely slow when attempting to access individual orders or set order status. Some pages take up to 10 seconds before they even begin to load. Once they load, they pop up quickly. Any thoughts?

Are you running the admin under SSL?

kobra:

Are you running the admin under SSL?

No, I am not.

Also, I've checked with my host, one of the certified hosts, and the server is running fine.

Hi, i have the same problem, was runnging fine on 1.3.5 then upgraded to 1.3.7 which was slow and now running 1.3.8.

sites pretty clean database and module wise and seems to be something that has changed in recent versions, not running ssl either.

although when i was it was the same.

It was suggested I implemented this fix, but if it helped something I can't tell. I still have to wait 5-10 seconds more than not when clicking on the details page of an order. And yes, I did the fix in the orders.php and index.php files.

This is just brutal. No one else is having this problem?

1. Which payment modules do you have enabled?

2. Is it slower for orders paid with one module vs another?

3. What is the order number of one that's exceptionally slow?

4. How many languages are configured in your store?

5. How many currencies?

6. The following can be obtained from your home page:

• How many "Specials" do you have set up?
• How many "Featured Products"?
• How many "Salemaker" sales are set up?
• In fact, a screenshot of your admin homepage with customer names blocked out would be helpful.

7. Use phpMyAdmin to export the STRUCTURE ONLY of the following tables:

• orders
• orders_products
• orders_products_attributes
• orders_products_download
• orders_status
• orders_status_history
• orders_total

(Click on Export, use CTRL+CLICK to select each of these tables from the left column. UNcheck the box that says "Data". DO NOT "Save as File" or use any compression ... just click Go and let it go to the screen. Then copy+paste the output here as a reply.)

Sorry about the delay in response. I was upgrading to 1.3.8 and hoped it would have helped...nope.

DrByte:

1. Which payment modules do you have enabled?

PPEC

2. Is it slower for orders paid with one module vs another?n/a

3. What is the order number of one that's exceptionally slow?Pretty much all new ones. This started around order 1700ish.

4. How many languages are configured in your store?1, just English

5. How many currencies?1, just USD

6. The following can be obtained from your home page:

• How many "Specials" do you have set up?0

• How many "Featured Products"?4

• How many "Salemaker" sales are set up?0

• In fact, a screenshot of your admin homepage with customer names blocked out would be helpful.[IMG]http://westcoastshaving.com/images/admin_small.jpg[/IMG]

7. Use phpMyAdmin to export the STRUCTURE ONLY of the following tables:

• orders
• orders_products
• orders_products_attributes
• orders_products_download
• orders_status
• orders_status_history
• orders_total

(Click on Export, use CTRL+CLICK to select each of these tables from the left column. UNcheck the box that says "Data". DO NOT "Save as File" or use any compression ... just click Go and let it go to the screen. Then copy+paste the output here as a reply.)```
-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 26, 2008 at 04:50 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: westgcom_zc2

--
-- Table structure for table zen_orders

CREATE TABLE zen_orders (
orders_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
customers_name varchar(64) NOT NULL default '',
customers_company varchar(32) default NULL,
customers_street_address varchar(64) NOT NULL default '',
customers_suburb varchar(32) default NULL,
customers_city varchar(32) NOT NULL default '',
customers_postcode varchar(10) NOT NULL default '',
customers_state varchar(32) default NULL,
customers_country varchar(32) NOT NULL default '',
customers_telephone varchar(32) NOT NULL default '',
customers_email_address varchar(96) NOT NULL default '',
customers_address_format_id int(5) NOT NULL default '0',
delivery_name varchar(64) NOT NULL default '',
delivery_company varchar(32) default NULL,
delivery_street_address varchar(64) NOT NULL default '',
delivery_suburb varchar(32) default NULL,
delivery_city varchar(32) NOT NULL default '',
delivery_postcode varchar(10) NOT NULL default '',
delivery_state varchar(32) default NULL,
delivery_country varchar(32) NOT NULL default '',
delivery_address_format_id int(5) NOT NULL default '0',
billing_name varchar(64) NOT NULL default '',
billing_company varchar(32) default NULL,
billing_street_address varchar(64) NOT NULL default '',
billing_suburb varchar(32) default NULL,
billing_city varchar(32) NOT NULL default '',
billing_postcode varchar(10) NOT NULL default '',
billing_state varchar(32) default NULL,
billing_country varchar(32) NOT NULL default '',
billing_address_format_id int(5) NOT NULL default '0',
payment_method varchar(128) NOT NULL default '',
payment_module_code varchar(32) NOT NULL default '',
shipping_method varchar(128) NOT NULL default '',
shipping_module_code varchar(32) NOT NULL default '',
coupon_code varchar(32) NOT NULL default '',
cc_type varchar(20) default NULL,
cc_owner varchar(64) default NULL,
cc_number varchar(32) default NULL,
cc_expires varchar(4) default NULL,
cc_cvv blob,
last_modified datetime default NULL,
date_purchased datetime default NULL,
orders_status int(5) NOT NULL default '0',
orders_date_finished datetime default NULL,
currency char(3) default NULL,
currency_value decimal(14,6) default NULL,
order_total decimal(14,2) default NULL,
order_tax decimal(14,2) default NULL,
paypal_ipn_id int(11) NOT NULL default '0',
ip_address varchar(96) NOT NULL default '',
qbi_imported tinyint(2) unsigned NOT NULL default '0',
PRIMARY KEY (orders_id),
KEY idx_status_orders_cust_zen (orders_status,orders_id,customers_id),
KEY idx_date_purchased_zen (date_purchased),
KEY qbi_imported (qbi_imported)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2101 ;

--
-- Table structure for table zen_orders_products

CREATE TABLE zen_orders_products (
orders_products_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
products_id int(11) NOT NULL default '0',
products_model varchar(32) default NULL,
products_name varchar(64) NOT NULL default '',
products_price decimal(15,4) NOT NULL default '0.0000',
final_price decimal(15,4) NOT NULL default '0.0000',
products_tax decimal(7,4) NOT NULL default '0.0000',
products_quantity float NOT NULL default '0',
onetime_charges decimal(15,4) NOT NULL default '0.0000',
products_priced_by_attribute tinyint(1) NOT NULL default '0',
product_is_free tinyint(1) NOT NULL default '0',
products_discount_type tinyint(1) NOT NULL default '0',
products_discount_type_from tinyint(1) NOT NULL default '0',
products_prid tinytext NOT NULL,
PRIMARY KEY (orders_products_id),
KEY idx_orders_id_prod_id_zen (orders_id,products_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2203 ;

--
-- Table structure for table zen_orders_products_attributes

CREATE TABLE zen_orders_products_attributes (
orders_products_attributes_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
orders_products_id int(11) NOT NULL default '0',
products_options varchar(32) NOT NULL default '',
products_options_values text NOT NULL,
options_values_price decimal(15,4) NOT NULL default '0.0000',
price_prefix char(1) NOT NULL default '',
product_attribute_is_free tinyint(1) NOT NULL default '0',
products_attributes_weight float NOT NULL default '0',
products_attributes_weight_prefix char(1) NOT NULL default '',
attributes_discounted tinyint(1) NOT NULL default '1',
attributes_price_base_included tinyint(1) NOT NULL default '1',
attributes_price_onetime decimal(15,4) NOT NULL default '0.0000',
attributes_price_factor decimal(15,4) NOT NULL default '0.0000',
attributes_price_factor_offset decimal(15,4) NOT NULL default '0.0000',
attributes_price_factor_onetime decimal(15,4) NOT NULL default '0.0000',
attributes_price_factor_onetime_offset decimal(15,4) NOT NULL default '0.0000',
attributes_qty_prices text,
attributes_qty_prices_onetime text,
attributes_price_words decimal(15,4) NOT NULL default '0.0000',
attributes_price_words_free int(4) NOT NULL default '0',
attributes_price_letters decimal(15,4) NOT NULL default '0.0000',
attributes_price_letters_free int(4) NOT NULL default '0',
products_options_id int(11) NOT NULL default '0',
products_options_values_id int(11) NOT NULL default '0',
products_prid tinytext NOT NULL,
PRIMARY KEY (orders_products_attributes_id),
KEY idx_orders_id_prod_id_zen (orders_id,orders_products_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=146 ;

--
-- Table structure for table zen_orders_products_download

CREATE TABLE zen_orders_products_download (
orders_products_download_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
orders_products_id int(11) NOT NULL default '0',
orders_products_filename varchar(255) NOT NULL default '',
download_maxdays int(2) NOT NULL default '0',
download_count int(2) NOT NULL default '0',
products_prid tinytext NOT NULL,
PRIMARY KEY (orders_products_download_id),
KEY idx_orders_id_zen (orders_id),
KEY idx_orders_products_id_zen (orders_products_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Table structure for table zen_orders_status

CREATE TABLE zen_orders_status (
orders_status_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
orders_status_name varchar(32) NOT NULL default '',
PRIMARY KEY (orders_status_id,language_id),
KEY idx_orders_status_name_zen (orders_status_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table zen_orders_status_history

CREATE TABLE zen_orders_status_history (
orders_status_history_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
orders_status_id int(5) NOT NULL default '0',
date_added datetime NOT NULL default '0001-01-01 00:00:00',
customer_notified int(1) default '0',
comments text,
PRIMARY KEY (orders_status_history_id),
KEY idx_orders_id_status_id_zen (orders_id,orders_status_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7386 ;

--
-- Table structure for table zen_orders_total

CREATE TABLE zen_orders_total (
orders_total_id int(10) unsigned NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
title varchar(255) NOT NULL default '',
text varchar(255) NOT NULL default '',
value decimal(15,4) NOT NULL default '0.0000',
class varchar(32) NOT NULL default '',
sort_order int(11) NOT NULL default '0',
PRIMARY KEY (orders_total_id),
KEY idx_ot_orders_id_zen (orders_id),
KEY idx_ot_class_zen (class)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6547 ;

I'm running QBI. Not sure if that can cause this problem.

Also, I had made these code changes with 1.3.7, which seemed to maybe help. I was going to make the same changes, but it looks like the base code changed and I'm not sure if this mod is appropriate now.