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

[rhodes]

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?

Regards

rhodes

 

[Paul B]

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

 

[Liam W]

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

 

[rhodes]

>>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

 

[Paul B]

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

 

[rhodes]

>>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?

 

[Mike]

No. You should never manually manipulate the DB unless you know exactly why you're doing it and the effect it will have.

 

[Chris D]

Since when is 29.9MB huge?

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

 

[MattW]

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

 

[Paul]

Since when is 29.9MB huge?

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

View attachment 66825

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