eZ performance with a large number of users

Wednesday 24 June 2009 2:00:55 am

I have to setup an eZ site which has a large number of users (>40.000). Besides standard fields, each user has a phone number attribute that can be searched for in eZ. So I would like to know how will this large number of users affect:

- performance of user login?
- performance when doing fetch for users based on attribute filter for the phone number attribute?

Does someone have experience with similar number of users?
How much difference in performance is between the number of 40.000 users and for example 2000?
Also, how much would a custom fetch operator that is specialized for retrieving users based on phone number improve the preformance?

P.S. I'm using eZ 3.10.1 and mysql database.

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Wednesday 24 June 2009 6:21:15 am

The main problem you will find having a number of users in the order of magnitude of 100.000 is the usability of the admin interface: if they are all part of the same group, navigating it becomes a pain, and you will have to resort to search for users or build a custom interface to easily find them. Storing them in folders by first letter of login might also be an idea.

Login is not a problem.

Heavy customization of the site based on user profile is a scalability brake anyway, even with few users: avoid having to fetch the user object on every page if you can.

Take care if putting the user id in cache block keys: you will generate a lot of those files.

Principal Consultant International Business
Member of the Community Project Board