If I have 19 profile fields and 600k users, that's 11.4 million rows in the profile_values table? Is that right? Seems crazy large. Is there a discussion about this somewhere I can find? Just inherited a site that was built some time ago. D5.10.
Thanks, -Dom
Sounds right, but 19 profile fields or 600,000 users seems crazy large too. ;)
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Domenic Santangelo Sent: Thursday, February 11, 2010 1:53 PM To: support@drupal.org Subject: [support] D5: profile_values
If I have 19 profile fields and 600k users, that's 11.4 million rows in the profile_values table? Is that right? Seems crazy large. Is there a discussion about this somewhere I can find? Just inherited a site that was built some time ago. D5.10.
Thanks, -Dom -- [ Drupal support list | http://lists.drupal.org/ ]
On Thu, Feb 11, 2010 at 2:53 PM, Domenic Santangelo domenics@gmail.com wrote:
If I have 19 profile fields and 600k users, that's 11.4 million rows in the profile_values table? Is that right? Seems crazy large. Is there a discussion about this somewhere I can find? Just inherited a site that was built some time ago. D5.10.
It is highly unlikely that they all have all 19 profile fields completed and the profile_values table only stores records if the user has completed the values. Do a count on the table - it's likely much lower.
That said, if you really do have 11 million rows you are probably going to want to look into a caching solution pretty soon.
Greg
Thanks for the replies. More below:
On Feb 12, 2010, at 8:08 AM, Greg Knaddison wrote:
On Thu, Feb 11, 2010 at 2:53 PM, Domenic Santangelo domenics@gmail.com wrote:
If I have 19 profile fields and 600k users, that's 11.4 million rows in the profile_values table? Is that right? Seems crazy large. Is there a discussion about this somewhere I can find? Just inherited a site that was built some time ago. D5.10.
It is highly unlikely that they all have all 19 profile fields completed and the profile_values table only stores records if the user has completed the values. Do a count on the table - it's likely much lower.
mysql> select count(*) from profile_values; +----------+ | count(*) | +----------+ | 8231901 | +----------+ 1 row in set (26.59 sec)
Ok, 8.2 million... and, it looks like 7.3M are empty:
mysql> select count(*) from profile_values where value = ""; +----------+ | count(*) | +----------+ | 7323269 | +----------+ 1 row in set (20.56 sec)
Was there a bug in core profile module that saved empty values to the db? This is D5.10, remember. I always used node_profile for my D5 sites and haven't run into this before. Although admittedly, it could be an application error (some custom module saving this info, for example).
Thanks for any advice, -Dom
Soooo.... nothin? Me, neither...
On Feb 12, 2010, at 2:13 PM, Domenic Santangelo wrote:
Thanks for the replies. More below:
On Feb 12, 2010, at 8:08 AM, Greg Knaddison wrote:
On Thu, Feb 11, 2010 at 2:53 PM, Domenic Santangelo domenics@gmail.com wrote:
If I have 19 profile fields and 600k users, that's 11.4 million rows in the profile_values table? Is that right? Seems crazy large. Is there a discussion about this somewhere I can find? Just inherited a site that was built some time ago. D5.10.
It is highly unlikely that they all have all 19 profile fields completed and the profile_values table only stores records if the user has completed the values. Do a count on the table - it's likely much lower.
mysql> select count(*) from profile_values; +----------+ | count(*) | +----------+ | 8231901 | +----------+ 1 row in set (26.59 sec)
Ok, 8.2 million... and, it looks like 7.3M are empty:
mysql> select count(*) from profile_values where value = ""; +----------+ | count(*) | +----------+ | 7323269 | +----------+ 1 row in set (20.56 sec)
Was there a bug in core profile module that saved empty values to the db? This is D5.10, remember. I always used node_profile for my D5 sites and haven't run into this before. Although admittedly, it could be an application error (some custom module saving this info, for example).
Thanks for any advice, -Dom
-
Domenic Santangelo -
Greg Knaddison -
Metzler, David