Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2014
    Location
    Czech republic
    Posts
    21
    Plugin Contributions
    0

    Default 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.p...ing-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.

  2. #2
    Join Date
    Dec 2011
    Location
    Wisconsin, USA
    Posts
    674
    Plugin Contributions
    21

    Default Re: Slow admin product page

    Quote Originally Posted by puhycz View Post
    Hi,

    I have problem with slow admin product page. (admin/categories.php i fix by http://www.zen-cart.com/showthread.p...ing-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

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  4. #4
    Join Date
    Apr 2014
    Location
    Czech republic
    Posts
    21
    Plugin Contributions
    0

    Default 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...

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Apr 2014
    Location
    Czech republic
    Posts
    21
    Plugin Contributions
    0

    Default 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]
    Hostnameort 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 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 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 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 .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

  7. #7
    Join Date
    Apr 2014
    Location
    Czech republic
    Posts
    21
    Plugin Contributions
    0

    Default 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"] 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"] 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

  8. #8
    Join Date
    Apr 2014
    Location
    Czech republic
    Posts
    21
    Plugin Contributions
    0

    Default Re: Slow admin product page

    Quote Originally Posted by Ajeh View Post
    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....

 

 

Similar Threads

  1. v155 Admin login page loads very slow.
    By oavs in forum General Questions
    Replies: 17
    Last Post: 18 Nov 2023, 01:38 PM
  2. Replies: 6
    Last Post: 10 Sep 2015, 08:12 AM
  3. v139h admin suddenly super slow, web store randomly slow
    By Swingin' Sparrow in forum General Questions
    Replies: 44
    Last Post: 13 Mar 2013, 07:50 AM
  4. v150 Admin suddenly became very slow on every page
    By Ashely in forum General Questions
    Replies: 2
    Last Post: 23 Sep 2012, 03:45 AM
  5. Admin page loads are very slow
    By AndyII in forum General Questions
    Replies: 7
    Last Post: 15 Feb 2009, 04:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg