---
title: Performance Tuning
description: Performance Tuning
---

[Skip to content](https://productcart-kb.nsource.com/kb/performance-tuning#main-content)

<https://productcart-kb.nsource.com/kb/kb-tickets/new?hsLang=en>

[![pc\_logo](https://productcart-kb.nsource.com/hs-fs/hubfs/pc_logo.png?width=162&height=75&name=pc_logo.png)](https://productcart.com/)

Open main navigation

Close main navigation

- <https://productcart-kb.nsource.com/kb/kb-tickets/new>
- [Contact Support](mailto:help@productcart.com)

[Contact Support](mailto:help@productcart.com)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [ProductCart Help Center](https://productcart-kb.nsource.com/kb?hsLang=en)
2. [Default](https://productcart-kb.nsource.com/kb/default?hsLang=en)

March 5, 2024

# Performance Tuning

## Website speed problems

Most of the performance issues relating to slow page loads in the storefront usually turn out to be related to hosting issues, or the inclusion of data from other web companies. We recommend using a tool such as : [http://www.webpagetest.org](http://www.webpagetest.org/) as a first and significant step in identifying the cause.

Database clean up

This is a standalone version of the script that is included in ProductCart (Help \> Database Clean Up Tool \> Remove customer sessions). If your database is extremely large it may be more efficient to run this standalone script directly against the database with SQL Manager.

You may use this script to completely remove unused data from your database. This tool will reduce the size of your database and may improve performance. This action is permanent and cannot be reversed. We strongly recommend that you backup your database before you run this clean up script.   
 

```

Declare @2Days AS DateTime 
Set @2Days = DATEADD(d, -2, GETUTCDATE())
DELETE FROM pcCustomerSessions WHERE pcCustSession_Date<@2Days

DELETE FROM configSessions 
WHERE configSessions.idconfigSession NOT IN 
(SELECT ProductsOrdered.idconfigSession FROM ProductsOrdered WHERE ProductsOrdered.idconfigSession<>0)
```

The following data will be removed when you run this tool:

- Expired customer sessions (pcCustomerSessions table)
- Expired configuration sessions (configSessions table)

- [Managing Your Products](https://productcart-kb.nsource.com/kb/managing-your-products?hsLang=en)
- [Managing Orders](https://productcart-kb.nsource.com/kb/managing-orders?hsLang=en)
- [Managing Customers](https://productcart-kb.nsource.com/kb/managing-customers?hsLang=en)
- [Getting Started](https://productcart-kb.nsource.com/kb/getting-started?hsLang=en)
- [Apparel Add-On](https://productcart-kb.nsource.com/kb/apparel-add-on?hsLang=en)
- [Upgrading ProductCart](https://productcart-kb.nsource.com/kb/upgrading-productcart?hsLang=en)
- [Change Logs](https://productcart-kb.nsource.com/kb/change-logs?hsLang=en)
- [Store Settings](https://productcart-kb.nsource.com/kb/store-settings?hsLang=en)
- [Security](https://productcart-kb.nsource.com/kb/security?hsLang=en)
- [Shipping Options](https://productcart-kb.nsource.com/kb/shipping-options?hsLang=en)
- [Payment Options](https://productcart-kb.nsource.com/kb/payment-options?hsLang=en)
- [Tax Options](https://productcart-kb.nsource.com/kb/tax-options?hsLang=en)
- [Advanced Technical Articles](https://productcart-kb.nsource.com/kb/advanced-technical-articles?hsLang=en)
- [Pages](https://productcart-kb.nsource.com/kb/pages?hsLang=en)
- [What's New In ProductCart](https://productcart-kb.nsource.com/kb/whats-new-in-productcart?hsLang=en)
- [Marketing](https://productcart-kb.nsource.com/kb/marketing?hsLang=en)
- [How To's](https://productcart-kb.nsource.com/kb/how-tos?hsLang=en)
- [Google Analytics](https://productcart-kb.nsource.com/kb/google-analytics?hsLang=en)
- [QuickBooks Sync](https://productcart-kb.nsource.com/kb/quickbooks-sync?hsLang=en)
- [Default](https://productcart-kb.nsource.com/kb/default?hsLang=en)
- [Configurator](https://productcart-kb.nsource.com/kb/configurator?hsLang=en)
- [SEO](https://productcart-kb.nsource.com/kb/seo?hsLang=en)
- [Mobile Commerce](https://productcart-kb.nsource.com/kb/mobile-commerce?hsLang=en)
- [Troubleshooting](https://productcart-kb.nsource.com/kb/troubleshooting?hsLang=en)
- [Customizing Your ProductCart Store](https://productcart-kb.nsource.com/kb/customizing-your-productcart-store?hsLang=en)
- [ProductCart Apps](https://productcart-kb.nsource.com/kb/productcart-apps?hsLang=en)
- [Hidden Topic](https://productcart-kb.nsource.com/kb/hidden-topic?hsLang=en)
- [Reports and Exports](https://productcart-kb.nsource.com/kb/reports-and-exports?hsLang=en)

[![ProductCart Logo](https://productcart-kb.nsource.com/hs-fs/hubfs/pc_logo.png?width=200&height=93&name=pc_logo.png "ProductCart Logo")](https://netsourceinc.com)

NetSource Commerce, Inc. **|** Headquarters - 3700 South Pine Avenue, Ocala, FL 34471 **|** Tel [(800) 709-3240](tel:+8007093240) **|** Fax (352) 401-0353

<https://www.facebook.com/productcartsoftware> <https://x.com/productcart?s=20> <https://www.linkedin.com/company/productcart/> [mailto:help@productcart.com](mailto:help@productcart.com)

Copyright © 2026, NetSource