ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

ge_relationships table

December 13, 2010 4:27am

Subscribe [2]
  • #1 / Dec 13, 2010 4:27am

    martinduys

    3 posts

    We have a site: http://www.gilt-edge.com that was developed by someone else and that I have inherited (with my very limited knowledge of EE).

    The site is running VERY slowly and our top priority is to speed it up. I know that we have a number of issues as per the report generated by the pagespeed addon for firefox, but it takes soooo long for anything to even start rendering in the page.

    One thing I am very worried about is the ge_relationships table.

    The table only has 1235 records in it but is over 40MB. The entire database is only 47MB.

    Is this normal? Am I right to be worried about the size of the table? The table has 5 columns two of which seem to be holding masses of data: “rel_data” and “reverse_rel_data”

    It looks like the data in there has something to do with the caching?

  • #2 / Dec 13, 2010 10:10am

    Sue Crocker

    26054 posts

    Hi, martinduys. I didn’t find the site to be slow loading up, but I do see a potential problem for your .css and .js files in your header. You should be using a / at the beginning of the path to the file. That won’t be as big of an issue on the first page, but may be in internal pages. It appears your site is using relationships, which may or may not cause you more overhead.

    Yes, those two fields are for caching..

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases