Zen Cart Logo
Forums / General Questions / Slow admin product page

Slow admin product page

Views: 12,108

Results 1 to 8 of 8
30 Jun 2014, 8:26 AM
#1
puhycz avatar

puhycz

New Zenner

Join Date:
Apr 2014
Location:
Czech republic
Posts:
21
Plugin Contributions:
0

Slow admin product page

Hi,

I have problem with slow admin product page. (admin/categories.php i fix by http://www.zen-cart.com/showthread.php?127089-admin-categories-php-running-super-slow and now is fast).

In shop is about 60000 products and is on dedicated webserver. Frontend is ok, but admin/product.php is slow still.

F.e. admin/product.php?page=1&product_type=1&cPath=94_98&pID=42726&action=new_product it´s about 12sec to load...

Admin categories.php load by 1sec - it's ok.

Where is problem?

Many thanks.

30 Jun 2014, 3:53 PM
#2
bislewl avatar

bislewl

Totally Zenned

Join Date:
Dec 2011
Location:
Wisconsin, USA
Posts:
674
Plugin Contributions:
12

Re: Slow admin product page

puhycz:

Hi,

I have problem with slow admin product page. (admin/categories.php i fix by http://www.zen-cart.com/showthread.php?127089-admin-categories-php-running-super-slow and now is fast).

In shop is about 60000 products and is on dedicated webserver. Frontend is ok, but admin/product.php is slow still.

F.e. admin/product.php?page=1&product_type=1&cPath=94_98&pID=42726&action=new_product it´s about 12sec to load...

Admin categories.php load by 1sec - it's ok.

Where is problem?

Many thanks.

Have you checked the error logs. it's the cache directory in 1.5.0 and prior and logs in 1.5.1 series.

Thanks,
Larry

30 Jun 2014, 11:49 PM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Slow admin product page

How many Products are in the Category that you are trying to add a new Product to, when it takes 12 seconds?

Have you perhaps a link to your sight where we could peek at the way your Products and Categories are laid out? :lookaroun

2 Jul 2014, 5:26 PM
#4
puhycz avatar

puhycz

New Zenner

Join Date:
Apr 2014
Location:
Czech republic
Posts:
21
Plugin Contributions:
0

Re: Slow admin product page

Error log is clear, there are f.e. 2 products... but this laq is in clear category too...

Site is puhy.cz

Thanks for any idea...

2 Jul 2014, 9:34 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Slow admin product page

When you are adding a Product and it is slow ... how many Products are in the Category that you are adding to?

If you go to the Tools ... Server Info ... can you paste in to a post everything from below the Menug and up to and including the PHP version?

I am testing on a site with 375,000 + Products and unless I have more than 1000 Products in a Catergory or a Category with even 10,000 in the Category, adding a Product is not slow by more than 2-3 seconds even if I set the Sort Order to a high value to put the Product at the end of the Category ...

3 Jul 2014, 5:51 AM
#6
puhycz avatar

puhycz

New Zenner

Join Date:
Apr 2014
Location:
Czech republic
Posts:
21
Plugin Contributions:
0

Re: Slow admin product page

Here is Server Information

Server Host: ds001 (91.217.53.74) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.32-56-server Database: MySQL 5.1.73-0ubuntu0.10.04.1
Server Date: 07/03/2014 07:49:36 Database Date: 07/03/2014 07:49:36
Server Up Time: 07:49:36 up 86 days, 17:56, 0 users, load average: 0.59, 0.89, 0.90 HTTP Server: Apache
PHP Version: 5.3.2-1ubuntu4.25 (Zend: 2.3.0) PHP Memory Limit: 600M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 20M POST Max Size: 20M
Database Data Size: 109,246 kB Database Index Size: 39,742 kB

Zen Cart
Zen Cart 1.5.0

Database Patch Level: 1.5.0

v1.5.0 [2014-02-23 16:57:14] (Version Update 1.3.9->1.5.0)
v1.3.9h [2014-02-23 16:57:12] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-02-24 22:18:10] (Fresh Installation)
PHP Version 5.3.2-1ubuntu4.25

System Linux ds001 2.6.32-56-server #118-Ubuntu SMP Mon Jan 6 19:05:28 UTC 2014 x86_64
Build Date Jun 20 2014 00:16:21
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php5/apache2
Loaded Configuration File /etc/php5/apache2/php.ini
Scan this dir for additional .ini files /etc/php5/apache2/conf.d
Additional .ini files parsed /etc/php5/apache2/conf.d/curl.ini, /etc/php5/apache2/conf.d/gd.ini, /etc/php5/apache2/conf.d/imagick.ini, /etc/php5/apache2/conf.d/imap.ini, /etc/php5/apache2/conf.d/mcrypt.ini, /etc/php5/apache2/conf.d/memcache.ini, /etc/php5/apache2/conf.d/mysql.ini, /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini, /etc/php5/apache2/conf.d/pdo_mysql.ini, /etc/php5/apache2/conf.d/snmp.ini, /etc/php5/apache2/conf.d/ssh2.ini, /etc/php5/apache2/conf.d/xcache.ini
PHP API 20090626
PHP Extension 20090626
Zend Extension 220090626
Zend Extension Build API220090626,NTS
PHP Extension Build API20090626,NTS
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
Zend Multibyte Support disabled
IPv6 Support enabled
Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip, ssh2.shell, ssh2.exec, ssh2.tunnel, ssh2.scp, ssh2.sftp
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters zlib., bzip2., convert.iconv., string.rot13, string.toupper, string.tolower, string.strip_tags, convert., consumed, dechunk

This server is protected with the Suhosin Patch 0.9.9.1
Copyright (c) 2006-2007 Hardened-PHP Project Copyright (c) 2007-2009 SektionEins GmbH

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd., and
with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technologies
with XCache v1.3.0, Copyright (c) 2005-2009, by mOo

Configuration

apache2handler

Apache Version Apache
Apache API Version 20051115
Server Administrator [email protected]
Hostname:Port puhy.cz:0
User/Group www-data(33)/33
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 15
Virtual Server Yes
Server Root /etc/apache2
Loaded Modules core mod_log_config mod_logio prefork http_core mod_so mod_actions mod_alias mod_auth_basic mod_auth_digest mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cache mod_dav mod_deflate mod_dir mod_env mod_expires mod_fcgid mod_filter mod_include mod_mem_cache mod_mime mod_php5 mod_reqtimeout mod_rewrite mod_setenvif mod_ssl mod_status mod_suexec

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment

Variable Value
HTTP_HOST https://www.puhy.cz
HTTP_CONNECTION keep-alive
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36
HTTP_REFERER http://www.puhy.cz/admin/whos_online.php
HTTP_ACCEPT_ENCODING gzip,deflate,sdch
HTTP_ACCEPT_LANGUAGE cs-CZ,cs;q=0.8
HTTP_COOKIE zenAdminID=6lbq8papjjsuj1oqqa27j5kuu2; zenid=45dre3qf9gdf2vrqgc8bdpfs65; __utma=90651035.1912913606.1402243704.1404326725.1404363635.70; __utmc=90651035; __utmz=90651035.1402243704.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
PATH /usr/local/bin:/usr/bin:/bin
SERVER_SIGNATURE no value
SERVER_SOFTWARE Apache
SERVER_NAME https://www.puhy.cz
SERVER_ADDR 91.217.53.75
SERVER_PORT 80
REMOTE_ADDR 91.217.53.81
DOCUMENT_ROOT /var/www/puhy.cz/web
SERVER_ADMIN [email protected]
SCRIPT_FILENAME /var/www/puhy.cz/web/admin/server_info.php
REMOTE_PORT 55652
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /admin/server_info.php
SCRIPT_NAME /admin/server_info.php

HTTP Headers Information

HTTP Request Headers
HTTP Request GET /admin/server_info.php HTTP/1.1
Host https://www.puhy.cz
Connection keep-alive
Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8
User-Agent Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36
Referer http://www.puhy.cz/admin/whos_online.php
Accept-Encoding gzip,deflate,sdch
Accept-Language cs-CZ,cs;q=0.8
Cookie zenAdminID=6lbq8papjjsuj1oqqa27j5kuu2; zenid=45dre3qf9gdf2vrqgc8bdpfs65; __utma=90651035.1912913606.1402243704.1404326725.1404363635.70; __utmc=90651035; __utmz=90651035.1402243704.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
HTTP Response Headers
Expires Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma no-cache
Vary Accept-Encoding
Content-Encoding gzip

bcmath

BCMath support enabled

Directive Local Value Master Value
bcmath.scale 0 0

bcompiler

bcompiler support enabled
bcompiler version 1.0.2s
current bytecode version 0.27
can parse bytecode version 0.20, 0.22, 0.27

Directive Local Value Master Value
bcompiler.debug 0 0
bcompiler.debugfile no value no value
bcompiler.detect_filedir On On
bcompiler.enabled On On

bz2

BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.5, 10-Dec-2007

calendar

Calendar support enabled

Core

PHP Version 5.3.2-1ubuntu4.25

Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions dl, system, shell_exec, escapeshellarg, escapeshellcmd, passthru, proc_close, proc_open, proc_get_status, proc_nice, proc_open, proc_terminate, popen, pclose, disk_free_space, disk_total_space, diskfreespace, fileinode dl, system, shell_exec, escapeshellarg, escapeshellcmd, passthru, proc_close, proc_open, proc_get_status, proc_nice, proc_open, proc_terminate, popen, pclose, disk_free_space, disk_total_space, diskfreespace, fileinode
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
error_append_string no value no value
error_log /var/www/clients/client1/web1/web/cache/myDEBUG-adm-1404366576-188311.log no value
error_prepend_string no value no value
error_reporting 22519 22527
exit_on_timeout Off Off
expose_php Off Off
extension_dir /usr/lib/php5/20090626 /usr/lib/php5/20090626
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors Off Off
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear
log_errors On On
log_errors_max_len 0 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 60 120
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 600M 128M
open_basedir /var/www/clients/client1/web1/web:/var/www/clients/client1/web1/tmp:/var/www/puhy.cz/web:/srv/www/puhy.cz/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 20M 20M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i [email protected] /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 20M 20M
upload_tmp_dir /var/www/clients/client1/web1/tmp no value
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.enable_gc On On

ctype

ctype functions enabled

curl

cURL support enabled
cURL Information 7.19.7
Age 3
Features
AsynchDNS No
Debug No
GSS-Negotiate Yes
IDN Yes
IPv6 Yes
Largefile Yes
NTLM Yes
SPNEGO No
SSL Yes
SSPI No
krb4 No
libz Yes
CharConv No
Protocols tftp, ftp, telnet, dict, ldap, ldaps, http, file, https, ftps
Host x86_64-pc-linux-gnu
SSL Version OpenSSL/0.9.8k
ZLib Version 1.2.3.3

date

date/time support enabled
"Olson" Timezone Database Version 0.system
Timezone Database internal
Default timezone Europe/Prague

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone Europe/Prague Europe/Prague

dba

DBA support enabled
Supported handlers cdb cdb_make db4 inifile flatfile

Directive Local Value Master Value
dba.default_handler flatfile flatfile

dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.7.6
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

ereg

Regex Library Bundled library enabled

exif

EXIF Support enabled
EXIF Version 1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

Directive Local Value Master Value
exif.decode_jis_intel JIS JIS
exif.decode_jis_motorola JIS JIS
exif.decode_unicode_intel UCS-2LE UCS-2LE
exif.decode_unicode_motorola UCS-2BE UCS-2BE
exif.encode_jis no value no value
exif.encode_unicode ISO-8859-15 ISO-8859-15

fileinfo

fileinfo support enabled
version 1.0.5-dev

filter

Input Validation and Filtering enabled
Revision $Revision: 294106 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value

ftp

FTP support enabled

gd

GD Support enabled
GD Version 2.0
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.3.11
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 6b
PNG Support enabled
libPNG Version 1.2.42
WBMP Support enabled

Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0

gettext

GetText Support enabled

hash

hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv

iconv support enabled
iconv implementation glibc
iconv library version 2.11.1

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1

imagick

imagick module enabled
imagick module version 2.1.1-rc1
imagick classes Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator
ImageMagick version ImageMagick 6.5.7-8 2012-08-17 Q16 http://www.imagemagick.org
ImageMagick copyright Copyright (C) 1999-2009 ImageMagick Studio LLC
ImageMagick release date 2012-08-17
ImageMagick Number of supported formats: 202
ImageMagick Supported formats 3FR, A, AI, ART, ARW, AVI, AVS, B, BGR, BMP, BMP2, BMP3, BRF, BRG, C, CAL, CALS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CRW, CUR, CUT, DCM, DCR, DCX, DDS, DFONT, DJVU, DNG, DOT, DPX, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FITS, FRACTAL, FTS, G, G3, GBR, GIF, GIF87, GRADIENT, GRAY, GRB, GROUP4, HALD, HISTOGRAM, HRZ, HTM, HTML, ICB, ICO, ICON, INFO, INLINE, IPL, ISOBRL, JNG, JP2, JPC, JPEG, JPG, JPX, K, K25, KDC, LABEL, M, M2V, M4V, MAP, MAT, MATTE, MIFF, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NULL, O, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG24, PNG32, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSD, PTIF, PWP, R, RADIAL-GRADIENT, RAF, RAS, RBG, RGB, RGBA, RGBO, RLA, RLE, SCR, SCT, SFW, SGI, SHTML, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UIL, UYVY, VDA, VICAR, VID, VIFF, VST, WBMP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, Y, YCbCr, YCbCrA, YUV

Directive Local Value Master Value
imagick.locale_fix 0 0

imap

IMAP c-Client Version 2007e
SSL Support enabled
Kerberos Support enabled

json

json support enabled
json version 1.2.1

libxml

libXML support active
libXML Compiled Version 2.7.6
libXML Loaded Version 20706
libXML streams enabled

mbstring

Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) backtrack check On
Multibyte regex (oniguruma) version 4.7.1

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml)
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value

mcrypt

mcrypt support enabled
Version 2.5.8
Api No 20021217
Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value

memcache

memcache support enabled
Version 3.0.4
Revision $Revision: 1.83.2.36 $

Directive Local Value Master Value
memcache.allow_failover 1 1
memcache.chunk_size 32768 32768
memcache.compress_threshold 20000 20000
memcache.default_port 11211 11211
memcache.hash_function crc32 crc32
memcache.hash_strategy consistent consistent
memcache.lock_timeout 15 15
memcache.max_failover_attempts 20 20
memcache.protocol ascii ascii
memcache.redundancy 1 1
memcache.session_redundancy 2 2

mhash

MHASH support Enabled
MHASH API Version Emulated Support

mysql

MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version 5.1.73
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient_r

Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli

MysqlI Support enabled
Client API library version 5.1.73
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.1.73
MYSQLI_SOCKET /var/run/mysqld/mysqld.sock

Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off

openssl

OpenSSL support enabled
OpenSSL Library Version OpenSSL 0.9.8k 25 Mar 2009
OpenSSL Header Version OpenSSL 0.9.8k 25 Mar 2009

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 7.8 2008-09-05

Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000

PDO

PDO support enabled
PDO drivers mysql

pdo_mysql

PDO Driver for MySQL enabled
Client API version 5.1.73

Phar

Phar: PHP Archive support enabled
Phar EXT version 2.0.1
Phar API version 1.1.1
SVN revision $Revision: 290435 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
OpenSSL support enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

Directive Local Value Master Value
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On

posix

Revision $Revision: 293036 $

Reflection

Reflection enabled
Version $Revision: 293036 $

session

Session Support enabled
Registered save handlers files user memcache
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn Off Off
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain .https://www.puhy.cz no value
session.cookie_httponly On Off
session.cookie_lifetime 0 0
session.cookie_path /admin /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 2 1000
session.gc_maxlifetime 900 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name zenAdminID PHPSESSID
session.referer_check no value no value
session.save_handler user files
session.save_path /var/www/clients/client1/web1/tmp /var/lib/php5
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies On On
session.use_trans_sid 0 0

shmop

shmop support enabled

SimpleXML

Simplexml support enabled
Revision $Revision: 293036 $
Schema support enabled

snmp

NET-SNMP Support enabled
NET-SNMP Version 5.4.2.1

soap

Soap Client enabled
Soap Server enabled

Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir /tmp /tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400

sockets

Sockets Support enabled

SPL

SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

ssh2

SSH2 support enabled
extension version 0.11.0-dev
libssh2 version 1.2.2
banner SSH-2.0-libssh2_1.2.2
remote forwarding enabled
hostbased auth enabled
polling support enabled
publickey subsystem enabled

standard

Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i [email protected]

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value

sysvmsg

sysvmsg support enabled
Revision $Revision: 293036 $

tokenizer

Tokenizer Support enabled

wddx

WDDX Support enabled
WDDX Session Serializer enabled

3 Jul 2014, 5:52 AM
#7
puhycz avatar

puhycz

New Zenner

Join Date:
Apr 2014
Location:
Czech republic
Posts:
21
Plugin Contributions:
0

Re: Slow admin product page

xml

XML Support active
XML Namespace Support active
libxml2 Version 2.7.6

xmlreader

XMLReader enabled

xmlwriter

XMLWriter enabled

Zend Guard Loader

Zend Guard Loader enabled
License Path no value
Obfuscation level 3

zip

Zip enabled
Extension Version $Id: php_zip.c 294817 2010-02-09 17:51:39Z pajoye $
Zip version 1.9.1
Libzip version 0.9.0

zlib

ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.1
Linked Version 1.2.3.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules

Module Name
ionCube Loader
sysvsem
sysvshm

Environment

Variable Value
APACHE_PID_FILE /var/run/apache2.pid
APACHE_RUN_USER www-data
PATH /usr/local/bin:/usr/bin:/bin
PWD /usr/local/ispconfig/server
APACHE_RUN_GROUP www-data
LANG C
SHLVL 1
_ /usr/sbin/apache2

PHP Variables

Variable Value
PHP_SELF /admin/server_info.php
_COOKIE["zenAdminID"] 6lbq8papjjsuj1oqqa27j5kuu2
_COOKIE["zenid"] 45dre3qf9gdf2vrqgc8bdpfs65
_COOKIE["__utma"] 90651035.1912913606.1402243704.1404326725.1404363635.70
_COOKIE["__utmc"] 90651035
_COOKIE["__utmz"] 90651035.1402243704.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
_SERVER["HTTP_HOST"] https://www.puhy.cz
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36
_SERVER["HTTP_REFERER"] http://www.puhy.cz/admin/whos_online.php
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate,sdch
_SERVER["HTTP_ACCEPT_LANGUAGE"] cs-CZ,cs;q=0.8
_SERVER["HTTP_COOKIE"] zenAdminID=6lbq8papjjsuj1oqqa27j5kuu2; zenid=45dre3qf9gdf2vrqgc8bdpfs65; __utma=90651035.1912913606.1402243704.1404326725.1404363635.70; __utmc=90651035; __utmz=90651035.1402243704.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
_SERVER["PATH"] /usr/local/bin:/usr/bin:/bin
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache
_SERVER["SERVER_NAME"] https://www.puhy.cz
_SERVER["SERVER_ADDR"] 91.217.53.75
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 91.217.53.81
_SERVER["DOCUMENT_ROOT"] /var/www/puhy.cz/web
_SERVER["SERVER_ADMIN"] [email protected]
_SERVER["SCRIPT_FILENAME"] /var/www/puhy.cz/web/admin/server_info.php
_SERVER["REMOTE_PORT"] 55652
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /admin/server_info.php
_SERVER["SCRIPT_NAME"] /admin/server_info.php
_SERVER["PHP_SELF"] /admin/server_info.php
_SERVER["REQUEST_TIME"] 1404366576

PHP License

3 Jul 2014, 7:13 AM
#8
puhycz avatar

puhycz

New Zenner

Join Date:
Apr 2014
Location:
Czech republic
Posts:
21
Plugin Contributions:
0

Re: Slow admin product page

Ajeh:

When you are adding a Product and it is slow ... how many Products are in the Category that you are adding to?

If you go to the Tools ... Server Info ... can you paste in to a post everything from below the Menug and up to and including the PHP version?

I am testing on a site with 375,000 + Products and unless I have more than 1000 Products in a Catergory or a Category with even 10,000 in the Category, adding a Product is not slow by more than 2-3 seconds even if I set the Sort Order to a high value to put the Product at the end of the Category ...

It´s the same lag for free category and for category with 1000 products too....