Hi every body, I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ? Thank you -- Farouk
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips? First tip: Don't use the hsqldb engine that's provided with the standalone XE package. As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users, is that in the same range as your target database? -- Sergiu Dumitriu http://purl.org/net/sergiu/
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome -Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server. XWiki has a abstract data model so a large database of users do not cause problems ? Also i have weekly users synchronization i guess use scheduler application for do that : http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication what you think? <http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks. -- Farouk 2009/11/24 Vincent Massol <[email protected]>
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Nearbee Farouk Korteby Technical Manager 75, Avenue Parmentier - 75544 Paris Cedex 11 Tel : +33 1 72 42 73 41 - Fax : +33 1 40 21 24 00 www.nearbee.com
On 11/24/2009 02:25 PM, farouk korteby wrote:
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server.
XWiki has a abstract data model so a large database of users do not cause problems ?
For increased performance you could enable custom mapping for the XWiki.XWikiUsers class. A mapping made some time ago is already present in the xwiki.hbm.xml file, commented out, near the end of the file. If you need additional fields in the user class, don't forget to add them in the mapping too.
Also i have weekly users synchronization i guess use scheduler application for do that : http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication what you think?
Where would you get the users from? Note that XWiki already has some support for LDAP/ActiveDirectory.
<http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks.
-- Farouk
2009/11/24 Vincent Massol<[email protected]>
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
I get my users data form XML files so i must do that by groovy or java. It's is a interesting idea to use a custom mapping for XWikiUsers in hibernate, but have i reason to think it don't impact the api for creating users "$xwiki.createUser()" ?? Thank's -- Farouk 2009/11/24 Sergiu Dumitriu <[email protected]>
On 11/24/2009 02:25 PM, farouk korteby wrote:
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server.
XWiki has a abstract data model so a large database of users do not cause problems ?
For increased performance you could enable custom mapping for the XWiki.XWikiUsers class. A mapping made some time ago is already present in the xwiki.hbm.xml file, commented out, near the end of the file. If you need additional fields in the user class, don't forget to add them in the mapping too.
Also i have weekly users synchronization i guess use scheduler application for do that : http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplicationwhat you think?
Where would you get the users from? Note that XWiki already has some support for LDAP/ActiveDirectory.
<http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks.
-- Farouk
2009/11/24 Vincent Massol<[email protected]>
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Nearbee Farouk Korteby Technical Manager 75, Avenue Parmentier - 75544 Paris Cedex 11 Tel : +33 1 72 42 73 41 - Fax : +33 1 40 21 24 00 www.nearbee.com
On 11/24/2009 04:03 PM, farouk korteby wrote:
I get my users data form XML files so i must do that by groovy or java.
It's is a interesting idea to use a custom mapping for XWikiUsers in hibernate, but have i reason to think it don't impact the api for creating users "$xwiki.createUser()" ??
Custom mapping affects only the storage, specifically when serializing objects in the database, the actual data will look and behave the same in the rest of the code.
Thank's -- Farouk
2009/11/24 Sergiu Dumitriu<[email protected]>
On 11/24/2009 02:25 PM, farouk korteby wrote:
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server.
XWiki has a abstract data model so a large database of users do not cause problems ?
For increased performance you could enable custom mapping for the XWiki.XWikiUsers class. A mapping made some time ago is already present in the xwiki.hbm.xml file, commented out, near the end of the file. If you need additional fields in the user class, don't forget to add them in the mapping too.
Also i have weekly users synchronization i guess use scheduler application for do that : http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplicationwhat you think?
Where would you get the users from? Note that XWiki already has some support for LDAP/ActiveDirectory.
<http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks.
-- Farouk
2009/11/24 Vincent Massol<[email protected]>
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
Thank's to you and to xwiki dev team. -- Farouk 2009/11/24 Sergiu Dumitriu <[email protected]>
On 11/24/2009 04:03 PM, farouk korteby wrote:
I get my users data form XML files so i must do that by groovy or java.
It's is a interesting idea to use a custom mapping for XWikiUsers in hibernate, but have i reason to think it don't impact the api for creating users "$xwiki.createUser()" ??
Custom mapping affects only the storage, specifically when serializing objects in the database, the actual data will look and behave the same in the rest of the code.
Thank's -- Farouk
2009/11/24 Sergiu Dumitriu<[email protected]>
On 11/24/2009 02:25 PM, farouk korteby wrote:
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server.
XWiki has a abstract data model so a large database of users do not cause problems ?
For increased performance you could enable custom mapping for the XWiki.XWikiUsers class. A mapping made some time ago is already present in the xwiki.hbm.xml file, commented out, near the end of the file. If you need additional fields in the user class, don't forget to add them in the mapping too.
Also i have weekly users synchronization i guess use scheduler application for do that :
http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplicationwhat
you think?
Where would you get the users from? Note that XWiki already has some support for LDAP/ActiveDirectory.
< http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks.
-- Farouk
2009/11/24 Vincent Massol<[email protected]>
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote: > Hi every body, > > I want to develop a platform based in XWiki Enterprise with a large > database > of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
Hi, I enabled the custom mapping for XWiki.XWikiUsers class in the xwiki.hbm.xml file and rebuild the xwiki-core-2.0.3 but it's not work. i add some new users but the "*SELECT * FROM `xwiki`.`xwikiusers`* " query return a empty list. but i found my new users with this query "*SELECT * FROM `xwiki`.`xwikiobjects` where xwo_classname='XWiki.XWikiUsers'*". where is the mistake ? 2009/11/24 farouk korteby <[email protected]>
Thank's to you and to xwiki dev team.
-- Farouk
2009/11/24 Sergiu Dumitriu <[email protected]>
On 11/24/2009 04:03 PM, farouk korteby wrote:
I get my users data form XML files so i must do that by groovy or java.
It's is a interesting idea to use a custom mapping for XWikiUsers in hibernate, but have i reason to think it don't impact the api for creating users "$xwiki.createUser()" ??
Custom mapping affects only the storage, specifically when serializing objects in the database, the actual data will look and behave the same in the rest of the code.
Thank's -- Farouk
2009/11/24 Sergiu Dumitriu<[email protected]>
On 11/24/2009 02:25 PM, farouk korteby wrote:
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server.
XWiki has a abstract data model so a large database of users do not cause problems ?
For increased performance you could enable custom mapping for the XWiki.XWikiUsers class. A mapping made some time ago is already present in the xwiki.hbm.xml file, commented out, near the end of the file. If you need additional fields in the user class, don't forget to add them in the mapping too.
Also i have weekly users synchronization i guess use scheduler application for do that :
http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplicationwhat
you think?
Where would you get the users from? Note that XWiki already has some support for LDAP/ActiveDirectory.
< http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks.
-- Farouk
2009/11/24 Vincent Massol<[email protected]>
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
> On 11/24/2009 12:11 PM, farouk korteby wrote: >> Hi every body, >> >> I want to develop a platform based in XWiki Enterprise with a large >> database >> of users, can you give me some tips ? > > What kind of tips? > > First tip: Don't use the hsqldb engine that's provided with the > standalone XE package. > > As far as I remember, Curriki (curriki.org) has somewhere around 40 > 000 > users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
> is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- --- Farouk Korteby
On 11/29/2009 11:38 AM, farouk korteby wrote:
Hi,
I enabled the custom mapping for XWiki.XWikiUsers class in the xwiki.hbm.xml file and rebuild the xwiki-core-2.0.3 but it's not work.
i add some new users but the "*SELECT * FROM `xwiki`.`xwikiusers`* " query return a empty list.
but i found my new users with this query "*SELECT * FROM `xwiki`.`xwikiobjects` where xwo_classname='XWiki.XWikiUsers'*".
where is the mistake ?
Did you create any new users after this? Just enabling the mapping does not transform existing users to the new table.
2009/11/24 farouk korteby<[email protected]>
Thank's to you and to xwiki dev team.
-- Farouk
2009/11/24 Sergiu Dumitriu<[email protected]>
On 11/24/2009 04:03 PM, farouk korteby wrote:
I get my users data form XML files so i must do that by groovy or java.
It's is a interesting idea to use a custom mapping for XWikiUsers in hibernate, but have i reason to think it don't impact the api for creating users "$xwiki.createUser()" ??
Custom mapping affects only the storage, specifically when serializing objects in the database, the actual data will look and behave the same in the rest of the code.
Thank's -- Farouk
2009/11/24 Sergiu Dumitriu<[email protected]>
On 11/24/2009 02:25 PM, farouk korteby wrote:
Ok that's cool, i have less than 10000 members, i use tomcat and mysql in my server.
XWiki has a abstract data model so a large database of users do not cause problems ?
For increased performance you could enable custom mapping for the XWiki.XWikiUsers class. A mapping made some time ago is already present in the xwiki.hbm.xml file, commented out, near the end of the file. If you need additional fields in the user class, don't forget to add them in the mapping too.
Also i have weekly users synchronization i guess use scheduler application for do that :
http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplicationwhat
you think?
Where would you get the users from? Note that XWiki already has some support for LDAP/ActiveDirectory.
< http://code.xwiki.org/xwiki/bin/view/Applications/SchedulerApplication> Thanks.
-- Farouk
2009/11/24 Vincent Massol<[email protected]>
> > On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote: > >> On 11/24/2009 12:11 PM, farouk korteby wrote: >>> Hi every body, >>> >>> I want to develop a platform based in XWiki Enterprise with a large >>> database >>> of users, can you give me some tips ? >> >> What kind of tips? >> >> First tip: Don't use the hsqldb engine that's provided with the >> standalone XE package. >> >> As far as I remember, Curriki (curriki.org) has somewhere around 40 >> 000 >> users, > > It currently has 93803 users :) > See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome > > -Vincent > >> is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
Curriki uses this patch for having implicit XWikiAllGroup http://jira.xwiki.org/jira/browse/CURRIKI-738 Otherwise I think we started having some issues at 40K users level.. We should have this get primetime by the way Ludovic Vincent Massol a écrit :
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
On 11/27/2009 07:46 PM, Ludovic Dubost wrote:
Curriki uses this patch for having implicit XWikiAllGroup
http://jira.xwiki.org/jira/browse/CURRIKI-738
Otherwise I think we started having some issues at 40K users level.. We should have this get primetime by the way
Committed. See my last comment on http://jira.xwiki.org/jira/browse/XWIKI-2116
Ludovic
Vincent Massol a écrit :
On Nov 24, 2009, at 1:07 PM, Sergiu Dumitriu wrote:
On 11/24/2009 12:11 PM, farouk korteby wrote:
Hi every body,
I want to develop a platform based in XWiki Enterprise with a large database of users, can you give me some tips ?
What kind of tips?
First tip: Don't use the hsqldb engine that's provided with the standalone XE package.
As far as I remember, Curriki (curriki.org) has somewhere around 40 000 users,
It currently has 93803 users :) See left panel on http://www.curriki.org/xwiki/bin/view/Main/WebHome
-Vincent
is that in the same range as your target database?
-- Sergiu Dumitriu http://purl.org/net/sergiu/
participants (4)
-
farouk korteby -
Ludovic Dubost -
Sergiu Dumitriu -
Vincent Massol