jos_TeraWurflCache 200Mb db!

Hi
I'm testing mobilejoomla on this site: m.mbnews.it
I'm working on template and other, but this morning looking at db I just discovered that jos_TeraWurflCache table is about 200Mb, is this correct?
the jos_content db is less than 50 Mb.

Joomla 1.5.22 on a dedicated server, mobilejoomla 0.9.8 caching global

theant wrote:


The size of jos_TeraWurflCache depends on how many different devices visit your site.
You can query "TRUNCATE TABLE jos_TeraWurflCache;" sometimes to drop the table data.
Also you can disable caching in TeraWURFL by setting

in plugins/mobile/terawurfl/TeraWurflConfig.php (but in this case getting device capabilities will take more time).

More than 13.000 different devices?

Could you give me the structure of that table because the script at installing the component didn't created it.

TeraWURFL creates jos_TeraWurflCache automatically at first usage.

It didn't created it, but I:

1..- Installed a standalone Joomla site on my desktop
2.- Install the mobile Joomla Component
3.- Verify is everything was ok (it was)
4.- Install the mobile joomla on my "alive" site
5.- backed up the tables from mobile joomla in the database of my stand alone installation (with drop option, thanks to phpmyadmin)
6.- Restored table from my database in "alive" site
7.- Restart S.O. (I have Windows... so the habit LOL)
8.- Run the site on my Android 2.2
9.- Check error_log in site, and behavior of tables (nothing weird found).
10.- ¡Good job pal!

This is some one else wants to try in that way, it is not the best, but mobile joomla is great and I won't lose the opportunity to use it. Thanks developers

Now I'll try to create my CRON JOB to tuncrate jos_TeraWurflCache by calling a php file with the enough information for it, wish me look since I and a super noob

I'll post it later along the day =)

Yeah this TeraWurflCache problem is unacceptable. Our cache table is more than 30,000 rows —almost 500 MB and even with bzip2 we can't get the database down to a reasonable size to import over phpmyadmin. TRUNCATE seems to be the only solution but there must be a more elegant solution. Also, all the Tera tables are in the joomla root, duplicated with mixed case and lowercase-named tables. Which are the proper tables to keep?