Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Fastest way to delete URL trash . 1,2 million URLs
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 3 (Joomla 1.5 compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Fastest way to delete URL trash . 1,2 million URLs

Fastest way to delete URL trash . 1,2 million URLs 11 years, 9 months ago #31229

I have over 1.2 million entries in the URL trash and would like to get rid of them..
the backend can't handle it .. I get timeout errors from my server ..
doing it by hundreds would take forever ..

how can I get rid of these?
could I just empty the table in the database?
The topic has been locked.

Re: Fastest way to delete URL trash . 1,2 million URLs 11 years, 9 months ago #31250

  • dajo
  • OFFLINE
  • Posts: 5069
Hi,
Yes you can delete them manually in database using the following SQL:
DELETE FROM jos_sefurls WHERE trashed = 1;

Of course you should backup your database before doing this in case something goes wrong.
ARTIO Support Team
The topic has been locked.
  • Page:
  • 1
User Login Empty