Re: a few (short) questions ...

At 15:34 10.11.2006, you wrote:


>Thank you very much for the help ... I still have doubts, so i'll try to make
>you another questions related with previous ones
>
>1) Which DB tables do I need to export in order to make a site clone ?
>(suppose I'm using community version)

All of them. There are no distinct tables per 
virtual site. Moreiver the DB relationship is 
directly managed by Hibernate 
(Object-Relationship Library), so I would clearly 
do not touch the DB without fully understanding 
the possible impact on the software.

>2) Where are the contents in the filesystem?

It depends. In Web-Inf/etc, you will have all the 
config files. In WEB-INF/var you will have all 
the binary files (if not stored in the DB), the 
search indexes,.... Of course the possible 
portlets you will deploy and use will be 
installed in your tomcat webapps directory. 
Templates JSPs are stored in webapps/jahia/jsp. 
etc... So if this is for backup purpose and you 
want to be sure to backup everything, please backup the full tomcat directory.

>3) Suppose that i upload a content: 10kb of text, and 90kb of images ( =
>100kb) .... how many kb's (approx) do I need in jahia environment (I suppose
>100kb + indexes + permisions + etc ...) ?. In other words ... how many kbs
>of overhead are needed in jahia for a content of X kb ??

Never calculated the overhead... but this is 
small. The size of the Jahia DB (without binary 
files) is most of the time less than 256Mb... So 
this should clearly not be a problem today givent 
the price of the hard drives ;-)... Else as 
mentionned, it really depends of the number of 
binary files you will store in the system... 
What's sure is that if you store 200GB of files, 
you will not have at the end 400GB of Jahia DB...

>I really apreciate your help... thanks in advance


You're welcome,
Stéphane



>Stéphane Croisier wrote:
> >
> > At 21:40 08.11.2006, you wrote:
> >
> >>Hi ..., I'm developing a banking site portal with jahia ..., I really
> >>apreciate if someone can answer me some questions
> >>
> >>1) Which DB tables do I need to export in order to make a site clone ?
> >
> > There is a site replication utility within Jahia.
> > You just need two jahia servers installed and
> > then you can replicate one virtual site on
> > another server's one through a "cron like" command (every hour, every
> > day,...)
> >
> >>2) It's posible to store all site information only in DB (not in DB and
> >>filesystem) ?
> >
> > Yes. During the installation wizard you have in
> > the DB advanced settings an option to enforce
> > rich texts + binary files storage. However you
> > still need some shared file access for the Lucene search index.
> >
> >>3) Is there an average filesystem growth measure for a site ?? for example
> >>kb/page (average)
> >
> > It really depends of the structure of your page
> > and the goal of your site (intranet which mainly
> > displays binary files or std web site pages)
> >
> >>4) The same as 3) for growth in DB
> >
> > Again, it depends of what you plan to store in
> > Jahia... But globally the size of the Jahia DB is
> > small (< 100Mb ) and will not grow a lot. Then it
> > really depends of the number of rich texts (large
> > text) + binary files you will store in your system.
> >
> > Regards,
> > Stéphane
> >
> >
> >>For 3) and 4) I supose an average page size, for example three paragraphs
>of
> >>text and two images .... An aproximate measure is enought ...
> >>
> >>Thanks in advance
> >>--
> >>View this message in context:
> >>http://www.nabble.com/a-few-%28short%29-questi 
> ons-...-tf2597690.html#a7246423
> >>Sent from the Jahia - Dev mailing list archive at Nabble.com.
> >
> >
> >
>
>--
>View this message in context: 
>http://www.nabble.com/a-few-%28short%29-questions-...-tf2597690.html#a7278015
>Sent from the Jahia - Dev mailing list archive at Nabble.com.