Re: [xwiki-users] Less resource-intensive plataform for XWiki?

Date: Wed, 27 Aug 2008 18:04:31 +0300> From: sergiu(a)xwiki.com> To: users(a)xwiki.org> Subject: Re: [xwiki-users] Less resource-intensive plataform for XWiki?> > Adriano Lopes wrote:>> >> I have XWiki 1.1-milestone-2.3619 available in my business. I use it as a repository for engineering technical information and legislation and as a Blog.>> >> My XWiki installation is the default one with the jetty container. I use Vista x64 SP1.>> >> The "xwiki_db.script" file is now over 3,5GB (mostly because I have many attachments) and I have set JAVA_OPTS=-Xmx2512m to be able to load XWiki. >> >> The process java.exe occupies 2,6GB of RAM memory. I have bought additional RAM reaching a total of 6GB to be able to use the computer while XWiki is loaded.>> >> XWiki as become an important part of my business and all my co-workers love to use it, so the information keeps growing.>> >> I will most certainly reach the maximum RAM (8GB) of my computer and will have to make large hardware investments if I am to continue using XWiki.>> >> Is there a less resource-intensive way for Xwiki to store attachments or a container more suitable for the way I use XWiki?>> > > Indeed, the most important thing is to change the underlying database > system, as HSQL is not meant to store large databases.> > As for the efficiency of storing attachments, this is a known problem > which should be fixed soon.> > -- > Sergiu Dumitriu> http://purl.org/net/sergiu/> _______________________________________________> users mailing list> users(a)xwiki.org> http://lists.xwiki.org/mailman/listinfo/usersWe've changed the underlying database to MySQL and installed it under ubuntu and all works much better now. The same database now occupies 2,6GB. The computer has 2GB RAM and a slow processor.We've upgraded to version 1.7 but this hole process wasn't easy because we haven't been able to use any import/export features so all the pages we're "copy/paste" transfered and all the attachments were re-uploaded.We've discovered that when uploading a file it takes up to 27x it's size on the server RAM, so you must set java_opts to 270MB to be able to load 10MB file. Is this a normal behavior?Adriano