Compress text?

Can we use PHP/MySQL to compress text?

[anshul]

Suppose we've a discussion-board or blog; users ( enthusiastic! ) posts hugh volumes of text/information into db; our db grows progressively ( 2 power n! ). Can we use PHP/MySQL to reduce our db size/volume? How?

[jatar_k]

what database/scripting language are you using now?

I don't know if you can specifically use php/mysql to decrease the size of your db, the amount of data you have is the amount of data you have. There could be options as to archiving or increasing hardware size.

What is the specific issue you are trying to resolve? I understand your db is probably too large but that isn't necessarily a problem.

Do you own the server?
co-location or shared host?
how much db room do you have?
could you output the db info to static pages?
could you offload onto another server that has more space?

Your question is very difficult to answer as I don't know anything about your situation and my recommendation would hinge on existing software/hardware as well as what the data requirements are.

[anshul]

edited: changed few bold words to normal.
--/
Thank you for your interest. I merely asked
this question; when read a 'checkbox' preceding text 'Compress articles (gzip)' in 'WordPress blog' 'PHPbb2 Forum'

> what database/scripting language are you using now?
This is PHP forum.
> Do you own the server? co-location or shared host? how much db room do you have?
Shared hosting. Limited db.

> could you output the db info to static pages?
Yes, this may be done.

> could you offload onto another server that has more space?
No