Log in Register
× Here you can get community support related to ReDJ.

How to reduce RedJ table sizes

  • Danielchat
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 6 months ago #6898 by Danielchat
How to reduce RedJ table sizes was created 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.

More
5 years 6 months ago #6899 by admin
Replied by admin on topic How to reduce RedJ table sizes
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
  • New Member
More
5 years 6 months ago #6901 by Danielchat
Replied by Danielchat on topic How to reduce RedJ table sizes
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.

More
5 years 6 months ago #6902 by admin
Replied by admin on topic How to reduce RedJ table sizes
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
  • New Member
More
5 years 6 months ago #6908 by Danielchat
Replied by Danielchat on topic How to reduce RedJ table sizes
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.

More
5 years 6 months ago #6910 by admin
Replied by admin on topic How to reduce RedJ table sizes
I will consider it, thank you.

Please Log in or Create an account to join the conversation.

Time to create page: 0.102 seconds