Performance

Submitted by markanson on Sat, 04/04/2009 - 22:25
Status: 
Open
Question: 

Has anyone got any reference information, with regard to the ability of this type of Drupal site using lots of modules, where there is some information about the performance of the Drupal system.

I've been looking at the database structure noting that the tables 'profile_fields' and 'content_node_field' that contain references to fields I created for user profile forms. If the system works this way then MySQL's performance would be much lower than, for instance if you have a table that has specific fields for items in the profile (firstname, lastname, dateofbirth etc).

For example in the lastname field in the table 'content_node_field' we have a 'db' column with this type of content: a:1:{s:5:"value";a:5:{s:4:"type";s:7:"varchar";s:6...

I understand how the JOINS in sql will be working in a scenario like this, and it makes me wonder about performance for the system.

I'm a bit concerned that in a heavily accessed system with hundreds of simultaneously logged in users, the database will be overloaded when it executes the SQL.

Does anyone know how this system will perform with a large number of users?

Related Questions

Back to all questions

Ask a new question!

Responses

1. Did you try the devel module to check?

Submitted by charos on Sun, 04/05/2009 - 05:36.

Hi,

Not sure if this is the approach you want but here is a tip :
You can check the http://drupal.org/project/devel module and with this measure DB query times, and duplicate queries for modules or pages

This might be useful for you:
If a module has slow query times look at tuning the tables with schema changes and using the the MySQL optimization tools, such as ANALYSE and EXPLAIN. Other areas for analysis are theme resource consumption if you theme has a lot of PHP calls.

If you check anything , please drop a feedback on most "demanding" modules here so all members can have an estimation on what to expect when their site goes "live".

I tried with this module but my lack of sql knowledge was the weakest link in the process so I let it go.

It is also nice to read the following article to get you started. The case scenario might be very close to most of us here!
http://pronovix.com/blog/my-favorite-drupal-performance-hacks

If you need some serious info about performance related issues for Drupal, there is only one site (and company) :
http://2bits.com/articles/drupal-performance-tuning-and-optimization-for...

I hope these helps.

2. I will look at this

Submitted by markanson on Sun, 04/05/2009 - 05:38.

Dorien I appreciate the feedback

I will look at these things you have referred to and report back to the community about the applications performance.

mark

3. once again

Submitted by charos on Sun, 04/05/2009 - 06:50.

I wish I was Dorien , but I'm not!