1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 How can I minimize my database tables (29MB)?

Discussion in 'XenForo Questions and Support' started by rhodes, Feb 8, 2014.

  1. rhodes

    rhodes Active Member

    Hello,

    I just wanted to upload my xf1.3 database from my local dev system to my webserver when I realized that one of my db tables is 29MB(!). That's a lot, isn't it?

    I tried to optimize xf_template_compiled (29MB). But this failed. "Table does not support optimize, doing recreate ".

    This is a fresh installation with 5 Testusers, two styles (base + uix) and about 20 empty forums. I already found a similar thread from @BamBam but can't find a solution for my problem.

    http://xenforo.com/community/thread...ompiled-xf_admin_log.35181/page-2#post-619756
    • Why is this DB table so huge?
    • What can I do to minimize it and keep it pretty slim in my production environment?
    Bildschirmfoto 2014-02-08 um 12.54.25.png

    Regards

    rhodes
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Other than zipping it when you export, there's not a lot you can do.
     
  3. Liam W

    Liam W Well-Known Member

    That table contains compiled templates. The BLOB column holds 'Executable PHP code built by template compiler'.

    If that table didn't exists, then templates would have to be compiled on every page load... Which would slow the site down considerably...

    Liam
     
  4. rhodes

    rhodes Active Member

    >>If that table didn't exists, then templates would have to be compiled on every page load...
    But isn't that table size of 29 MB too big? I just was astonished because the forum is empty and only has 5 users. What if we have 10000 users and 20000 threads?

    Rhodes
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    That table isn't affected by user or post counts.
    It is related to styles and templates only.
     
    Liam W likes this.
  6. rhodes

    rhodes Active Member

    >>That table isn't affected by user or post counts.
    >>It is related to styles and templates only.

    Ok, fine. When I empty this table before uploading the db will it then be automaticaly restored on the live system?
     
  7. Mike

    Mike XenForo Developer Staff Member

    No. You should never manually manipulate the DB unless you know exactly why you're doing it and the effect it will have.
     
    Divvens likes this.
  8. Chris D

    Chris D XenForo Developer Staff Member

    Since when is 29.9MB huge?

    I think you'll find that this is much more huge:

    upload_2014-2-8_18-31-9.png
     
    MattW likes this.
  9. MattW

    MattW Well-Known Member

    29MB isn't that big in the grand scheme of things. At least it's not going to get much larger over time.
     
    0ptima likes this.
  10. Paul

    Paul Well-Known Member

    Yikes - and i thought my old db was large at 4.7gb before i had a mass prune!!!
     

Share This Page