Some common data structure proposals.

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
1/5/2008 6:09:46 AM
bob
Gravatar
Total Posts 126
View Posts
YAF developer

Some common data structure proposals.

Let me  propose some small data  optimizations (imho). 

As to mojoPortal.Business.SiteUser:

Country property can be used as byte type , but not as the string type. An XML file can  store the number - country data.

Gender property can be used as bool or byte data type and TYNYINT  (1)  in MySql data layer case.

ICQ property can be used as UInt32 or int data type.

Of cause, it requires some data layer changes. All this can make the application a tiny bit more fast.

It can be useful to add Skype and Jabber data fields too.

1/5/2008 6:59:45 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Some common data structure proposals.

Hi Bob,

The user profile system is completely customizable so you can easily add Skype and Jabber to your site if those properties are of interest to you. You only have to declare them correctly in mojoProfile.config. See the documentation here:

http://mojoportal.com/userprofileconfiguration.aspx

Custom profile properties come from the mp_UserProperties table and are stored as text data in key value pairs. Some properties were already existing before I created the custom profile feature so these properties are mapped by name to existing columns in mp_Users.

I'm not really interested at this time in optimizing the data types for existing fields in mp_Users for several reasons.

1. I have limited time and there are much more fruitful things to work on
2. The benefit of these optimizations would be so small that they would be hard to measure. Furthermore they are already more optimized than the custom properties in mp_UserProperties. We are already favoring flexibility over optimization here.
3. There is potential to introduce bugs by fixing things that are not broken

Best Regards,

Joe

You must sign in to post in the forums. This thread is closed to new posts.