Customizing ProductCart - Category Index Fragmentation

Print Page | Close Window

Category Index Fragmentation

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=5931
Printed Date: 16-September-2024 at 3:50pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Category Index Fragmentation

Posted By: Polly
Subject: Category Index Fragmentation
Date Posted: 19-September-2014 at 3:17pm

Our categories have been a bit slow for a while (off and on), and all of a sudden we are suddenly experiencing HUGE slowdowns for customers clicking on our categories.

The categories dbo was 87.5% fragmented. We re-indexed it and 5 minutes later, it was already 75% fragmented again. Anyone experienced this, to have an idea what might be causing it?

Everyone says "Nope, I haven't made any changes to how we handle categories or db queries recently".

Thanks

-------------
~~ R&T systems director