Re: [support] D5: profile_values

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