List of all treads sorted by KB
 

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

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

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.

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.

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

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!