Very Slow Site

[gjh42]

It is a standard suggestion to turn off "Who's Online" for speed issues. Likewise the categories menu counts.
You can select file or db caching at setup. Not sure how to change it later.

The dev team is working on dramatic improvements in db use which will be out in the next few releases. See the Roadmap above.

[larryhyman]

how do i turn off whos online?

also here is my config file:

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/services/webpages/c/a/canadascrubs.com/public/catalog/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'xxxxxxxxxxxx');
define('DB_SERVER_USERNAME', 'xxxxxxxxxx');
define('DB_SERVER_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxxxxxxx');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', ''); // use 'db' for best support, or '' for file-based storage
// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/services/webpages/c/a/canadascrubs.com/public/catalog/cache');

[larryhyman]

SO....

[FONT=Times New Roman]The slowness occurs when there are concurrent attempts to update some key tables. db_cache appears to take the place of a session file in php. As always, we can't control how an application is written but the use of a database for this will always be slower than if one allowed php and the webserver to control the session file itself. Necessarily, if the session table (db_cache in this case) has to be written to, no-one can read from it. With php controlled sessions, everyone has their own session file, so there is no such waiting.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]What would be the best setting?[/FONT]
[FONT=Times New Roman][/FONT]
// For SQL_CACHE_METHOD, you can select from: none, database, or file

and

define('STORE_SESSIONS', ''); // use 'db' for best support, or '' for file-based storage


also, how do i fix the whois issue?

[FONT=Times New Roman]The use of whos_online also consumes resources. It too can lock up as it is constantly being updated, edited and written to. This application will slow down with time, but even though we, as visitors, are not viewing the current on line statistics, as we move around this table has to be updated and we don't get our page until it is[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]or should I just assume 3 sec a page is going to be the best that I'm going to get?[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you for any help ![/FONT]