[PHP-DB] Mysql compress text field?

[Patricio Vera S.]

Hello to all,

I have a new project where i need show pages of report on demmand. That
reports are created in the batch process, and the whole file size is about 5
Gb. (thats includes all the reports in a month, I need save about 12 month).

I think in two alternatives :

1. I save the links in a mysql database, but the files are compressed
(in zip format) in several directories, one directorie by day, so when the
user request one report, I query the database, go to the path, decompress
the file and return to the user.

2. I save the reports on the mysql database, so when the user request
one report, I query the database and return the report. But if MySql don't
compress the text field, that way is not practicable (HDD is limited).

Any ideas or suggestions?

Saludos,
Patricio Vera S.

___
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito 
en http://moviles.yahoo.es

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mysql compress text field?

[1LT John W. Holmes]

 I have a new project where i need show pages of report on demmand.
That
 reports are created in the batch process, and the whole file size is about
5
 Gb. (thats includes all the reports in a month, I need save about 12
month).

 I think in two alternatives :

 1. I save the links in a mysql database, but the files are compressed
 (in zip format) in several directories, one directorie by day, so when the
 user request one report, I query the database, go to the path, decompress
 the file and return to the user.

Use this method.

 2. I save the reports on the mysql database, so when the user request
 one report, I query the database and return the report. But if MySql don't
 compress the text field, that way is not practicable (HDD is limited).

You'd have to zip the files, then read the data to insert into the table.
Then, to retrieve, you'd have to select the data out, write it to a file and
unzip it before you sent it to the user. (According to your remarks) Sounds
like a lot of wasted time to me.

---John Holmes...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php