Fóruns

Início » Liferay Portal » English » 6. Portal Framework

Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Vishal Verma
Dynamic Data List - Load benchmark required
11 de Março de 2012 04:46
Resposta

Vishal Verma

Ranking: New Member

Mensagens: 2

Data de entrada: 11 de Março de 2012

Mensagens recentes

Hi,

For some of our dynamic data needs, we plan to leverage dynamic data list - and not go for traditional sql-table/portlet development. The decision is dependent on the scalabilty of dynamic data list and reporting capability on multiple data lists.
Would anyone be able to shed more info on this topic?

In simpler terms, would DDL be able to support data in the range of 1million rows, with ~10 attributes per row.

Regards,
Vishal
James Falkner
RE: Dynamic Data List - Load benchmark required
11 de Março de 2012 15:19
Resposta

James Falkner

LIFERAY STAFF

Ranking: Liferay Legend

Mensagens: 1348

Data de entrada: 17 de Setembro de 2010

Mensagens recentes

Vishal Verma:
Hi,

For some of our dynamic data needs, we plan to leverage dynamic data list - and not go for traditional sql-table/portlet development. The decision is dependent on the scalabilty of dynamic data list and reporting capability on multiple data lists.
Would anyone be able to shed more info on this topic?

In simpler terms, would DDL be able to support data in the range of 1million rows, with ~10 attributes per row.

Regards,
Vishal



You may find this research and presentation from oscon last year interesting. When using expando, I did several tests with up to 100M unique values for expando. Not sure how performant this would be if you used XML (which is the default), but when using Expando, it performed reasonably well at the 1M mark. My guess is that XML would not be as scalable as using Expando (which uses the underlying rdbms), and that I know that using a nosql-based solution is better than an rdbms solution at higher scales.
Vishal Verma
RE: Dynamic Data List - Load benchmark required
11 de Março de 2012 20:01
Resposta

Vishal Verma

Ranking: New Member

Mensagens: 2

Data de entrada: 11 de Março de 2012

Mensagens recentes

Alright, that gives me good head-start into the options we have at hand.
Let me do some ground work on this information and come back with specific questions, if any.

Appreciate your help. Thank you.