List of all treads sorted by KB

[Derek_Trotter]

Is it possible to have list of all treads sorted by kilobytes?
Thanks

[Marco van Herwaarden]

Kb of what? The text inside the message? Number of bytes in attachments in the whole thread/1st post?

[Derek_Trotter]

I whose thinking about table POST and only text content.
Something like: SELECT(how many kb) FROM 'POST' GROUP BY TREADID ....
It would be nice tool for forum administrators when they want to do some cleaning.

[Derek_Trotter]

Is there any way to see some memory report(statistic) from table POST.
My forum database is growing to fast and I need to know what can I do to control it.

[Marco van Herwaarden]

You can already see the size of a table in Maintenance -> Repair Optimise Tables. You might want check in more details using a tool like phpMyAdmin.

Most likely the post table is not the biggest, it is mostly just text.

Do you have a lot of attachments and where do you store them? Also what do you consider "growing too fast"?

[Derek_Trotter]

I moved attachments from database and now my biggest table is post.
When I start to do backup from cpanel I blocked whole server.
My database is around 200MB and it keep growing for 1MB each day. I don't have whole server for my self , just use simple hosting(400Mb 50GB bandwith).I am afraid if I not solve backup problem, my account will be compromised.
Thanks anyway Marko!