#4 Or You can use <a href="http://drupal.org/project/properties">http://drupal.org/project/properties</a> or something like that for a huge fields data<br clear="all"><div><font size="1"><b>---------------------------------------------------------------------------------------------------------------------------------------------------------<br>
</b></font></div><div><font size="1"><b>Andriy Podanenko</b></font><font size="1"><br></font></div><font size="1"><i>podarok@ + podarokua@ + podarok_ua@</i></font><font size="1"><br></font><div><a href="http://my.ukrweb.info/blog" target="_blank"><font size="1">Own Blog</font></a><font size="1"> | </font><a href="http://podanenko.com" target="_blank"><font size="1">Homepage</font></a><font size="1"> | </font><a href="http://twitter.com/podarok" target="_blank"><font size="1">Twitter</font></a><font size="1"> | </font><a href="http://www.linkedin.com/in/podarok" target="_blank"><font size="1">LinkedIn</font></a><font size="1"> | </font><a href="http://www.profeo.ua/podarok" target="_blank"><font size="1">Profeo</font></a><font size="1"> | </font><a href="http://vkontakte.ru/podarokua" target="_blank"><font size="1">vKontakte</font></a><font size="1"> | </font><a href="http://connect.ua/user-657054" target="_blank"><font size="1">Connect</font></a><font size="1"> | </font><a href="http://www.facebook.com/podarok" target="_blank"><font size="1">Facebook</font></a><font size="1"> | </font><a href="http://friendfeed.com/podarok" target="_blank"><font size="1">FriendFeed</font></a><font size="1"> | <a href="http://drupal.org/user/116002" target="_blank">Drupal ID</a> | <a href="http://drupal.ua/users/podarok" target="_blank">Drupal UA ID</a> | <a href="http://pulse.yahoo.com/_3SZUYBNZG4OQJCUJOZYF2D3UJY" target="_blank">Yahoo ID</a> | <a href="http://www.slideshare.net/podarok" target="_blank">SlideShare</a> | <a href="http://www.delicious.com/podarok" target="_blank">Delicious</a> | <a href="http://cid-3c79f9bdf923693a.profile.live.com/" target="_blank">Live ID</a> | <a href="http://www.google.com/profiles/podarokua" target="_blank">Google ID</a> | <a href="http://www.formspring.me/podarokua" target="_blank">Formspring</a> | <a href="http://digg.com/podarok" target="_blank">Digg</a> |</font><font size="1"><br>
</font></div><div><font size="1"><span style="background-color:#3333ff"><span style="background-color:#ffffff"><font color="#990000">WMID</font></span></span></font><font size="1"> <b>560874932971</b> | </font><font size="1"><span style="background-color:#990000"><span style="background-color:#ffffff"><font color="#660000">ICQ</font></span></span> <b>499918925</b> | </font><font size="1"><font color="#990000">YahooIM</font> <b>podarok_ua</b> | <font color="#990000">Jabber</font> <b><a href="mailto:podarok@jabber.org" target="_blank">podarok@jabber.org</a></b> | <font color="#990000">Gtalk</font> <b>podarokua</b> | <font color="#990000">AIM</font> <b>podarokua</b> |</font><font size="1"> | | |</font><font size="1"><br>
</font></div><div style="margin-left:40px"><font size="1"><i><font color="#cc0000">Меня не интересует, почему «нет», меня интересует, что нужно сделать для того, чтобы было «да»</font></i><br></font></div><br>
<br><br><div class="gmail_quote">2011/10/20 Ernst Plüss <span dir="ltr"><<a href="mailto:ernst.pluess@gmail.com">ernst.pluess@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I know of two reasons why this is:<br>
<br>
1. You can have different revisions by field.<br>
2. You can translate by field<br>
<br>
By normalizing the DB tables this is much easier to accomplish.<br>
<br>
BUT: You are right DB performance, especially write performance is<br>
very bad. I've seen a big drupal project failing because we had about<br>
300 DB tables for a lot of fields.<br>
<br>
If you have big and complex data structures the standard field<br>
implementation of Drupal 7 will not make you happy. I think you have<br>
the following options:<br>
<br>
1. Use MongoDB. There is a fields storage engine module in Drupal 7.<br>
The only problem I see is much less mature DB system than MySql or<br>
Postgress DB.<br>
2. User entities API. This is of course much more work, especially if<br>
you have to write alle the views and may be fields integration.<br>
3. Look for something else then Drupal. Currently we go for Ruby on<br>
Rails with Hobo for projects with a lot (>10-200) business entities.<br>
<br>
HTH<br>
Ernst<br>
<br>
<br>
<br>
2011/10/20 Mukesh Agarwal <<a href="mailto:mukesh.agarwal17@gmail.com">mukesh.agarwal17@gmail.com</a>>:<br>
<div><div></div><div class="h5">> Hi Everyone,<br>
> I'm sure I'm asking a question that people might have been asking for long.<br>
> Please bear my ignorance on following all the development threads.<br>
> I'm right now designing information architecture for one of my clients in<br>
> Drupal 7 and it turns out that there are many attributes associated to the<br>
> entities. Now that CCK fields are all stored in separate tables, my node<br>
> pages now have sql queries that have numerous joins and the performance goes<br>
> for a toss.<br>
> Does anyone know a good reason for moving from the previous schema? Single<br>
> valued cck fields are in the content type and multiple valued fields form a<br>
> new table. What was wrong with that?<br>
> --<br>
> Cheers,<br>
> Mukesh Agarwal<br>
> ________________________________<br>
> Innoraft Solutions || <a href="tel:%2B91%208017220799" value="+918017220799">+91 8017220799</a><br>
><br>
</div></div></blockquote></div><br>