Why an "Awaiting moderation" text appears instead of my comments?
a few (short) questions ...
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > Content Management System > a few (short) questions ... 13 November 2006 10:39:16

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

a few (short) questions ...

Gustav 13 November 2006 10:39:16
 
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 ?
2) It's posible to store all site information only in DB (not in DB and
filesystem) ?
3) Is there an average filesystem growth measure for a site ?? for example
kb/page (average)
4) The same as 3) for growth in DB

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.c­om/a-few-%28short%29­-questions-...-tf259­7690.html#a7246423
Sent from the Jahia - Dev mailing list archive at Nabble.com.


Add comment
St phane Croisier 9 November 2006 19:31:45 permanent link ]
 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%2­9-questions-...-tf25­97690.html#a7246423>­Sent from the Jahia - Dev mailing list archive at Nabble.com.


Add comment
Gustav 10 November 2006 17:34:01 permanent link ]
 
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)
2) Where are the contents in the filesystem?
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 ??

I really apreciate your help... thanks in advance


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
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-questions-...-tf2­597690.html#a7246423­>>Sent from the Jahia - Dev mailing list archive at Nabble.com.>

--
View this message in context: http://www.nabble.c­om/a-few-%28short%29­-questions-...-tf259­7690.html#a7278015
Sent from the Jahia - Dev mailing list archive at Nabble.com.


Add comment
St phane Croisier 13 November 2006 10:39:16 permanent link ]
 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-Relationshi­p 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.h­tml#a7246423> >>Sent from the Jahia - Dev mailing list archive at Nabble.com.> >
-->View this message in context: >http://www.nabble.­com/a-few-%28short%2­9-questions-...-tf25­97690.html#a7278015>­Sent from the Jahia - Dev mailing list archive at Nabble.com.


Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > Content Management System > a few (short) questions ... 13 November 2006 10:39:16

see also:
tough one
Gif into page.
Need to scan MySQL table
пройди тесты:
see also:
A CAMERA REVOLUTION!
ICONS: Apple OS X
AntiVir Removal Tool for Windows ...

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .