Category Index Fragmentation

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Polly Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 26-August-2008 Location: Spokane Status: Offline Points: 7	Post Options Post Reply Quote Polly Report Post Thanks(0) Quote Reply Topic: Category Index Fragmentation 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