Mysql compress text field?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



    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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux