All project content is available for reading, but you need to be a member of the project for Subversion checkout of source code, or to create/modify any information.
Login if you are a member. Apply here to request membership (open to all).

Ticket #350 (closed question: fixed)

Opened 8 years ago

Last modified 8 years ago

Question: Delete all suggestions from database?

Reported by: thomas@… Owned by: permagne@…
Priority: major Component: 404Handler
Keywords: Cc: fmsftst@…


Our 404-gadget is really slow, and in our BVN.not_found-table we have over 7 million rows. I assume that the gadget is slow as a consequence of the large amount of data?

Question: Is it safe to delete all rows from BVN.notfound? Will my redirects remain intact (dds?)

Change History

comment:1 Changed 8 years ago by permagne@…

I assume you are using EPiServer 6? If not, there is a tool for this for the 7 version. See http://world.episerver.com/Blogs/Per-Magne-Skuseth/Dates/2013/2/404-handler-for-EPiServer-7/

If this indeed is an EPiServer 6 site, then you you should be able to delete all rows manually, without getting in trouble. However, I would recommend trying it out in the dev. or test environment prior to doing it in production.

comment:2 Changed 8 years ago by thomas@…

  • Status changed from new to closed
  • Resolution set to fixed

Yes, it's EPiServer 6. I just deleted all rows in the live-database, and it still works :-) (we have a test-environment, but what's the fun in that?)

Thank you! :-)

comment:3 Changed 8 years ago by sachinsurana@…


Which tables did you delete it from? I see something stored in big tables as well which is too risky to delete.


comment:4 Changed 8 years ago by sachinsurana@…

  • Status changed from closed to reopened
  • Resolution fixed deleted

comment:5 Changed 8 years ago by thomas@…

  • Status changed from reopened to closed
  • Resolution set to fixed

I think I only deleted from the BVN.not_found-table and didn't touch the big tables. But I'm not 100% sure :p

Note: See HelpUser/Tickets for help on using tickets.