How to reduce RedJ table sizes
-
Danielchat
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 4
-
Thank you received: 0
-
-
6 years 2 months ago #6898
by Danielchat
Our redj_visited_urls table is several Gb.
How can we reduce the size without emptying the whole table? We would like to keep the information for either a period of time or a certain number of records (last X record).
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 3194
-
Thank you received: 441
-
-
6 years 2 months ago #6899
by admin
Hi,
unfortunately tables visited_urls, referer_urls and referers are strictly connected (i.e. each entry in the referers has a foreign key on an entry of the visited_urls, and another one on an entry of the referer_urls). So it is not possible to simply delete entries from the visited_urls tables being sure to not delete an item in use (pointed by referers).
A good solution could be to write a (sql) script to extract only the most recent entries from the referers (e.g. last month) in a new table, and to build the referred tables accordingly. At the end replace the new with the old ones.
But this is just my first idea, there is no automatic process to do this ATM.
Kind regards
Luigi
Please Log in or Create an account to join the conversation.
-
Danielchat
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 4
-
Thank you received: 0
-
-
6 years 2 months ago #6901
by Danielchat
And do you have this type of sql script?
I think it could be useful for everybody using this extension as the size of the table can only go up today.
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 3194
-
Thank you received: 441
-
-
6 years 2 months ago #6902
by admin
Unfortunately as I told before I do not have nothing to accomplish this.
Sorry
Please Log in or Create an account to join the conversation.
-
Danielchat
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 4
-
Thank you received: 0
-
-
6 years 2 months ago #6908
by Danielchat
Maybe it is an idea for a future release. It would be very useful to delete all entries older than a certain date.
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 3194
-
Thank you received: 441
-
-
Time to create page: 0.146 seconds