We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum
Perch2_collection_index table is pretty, pretty big
I'm developing a site with Perch Runway.
I noticed that the SQL file was getting rather large – 46Mb. Upon further inspection I saw that the collection_index table has ballooned to 300k+ lines, give or take. Saving any items in collections took forever. I've only got 4 collections with 45 items in total. Some are related mind you.
I've resolved this on the dev site by emptying the table and re-saving all the collections again. It's now 6,986 lines and all works fine again.
- Is this a BAD thing to do? (I'm guessing, yes!)
- Is there a script I can run to delete orphaned lines in the database that would be less drastic?
- Have I unearthed a bug and, if so, what do I win? I have the offending SQL file if it helps.
Many thanks in advance,
Want to reply to this thread?Login with Perch