Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Vishal Verma
Dynamic Data List - Load benchmark required
March 11, 2012 4:46 AM
Answer

Vishal Verma

Rank: New Member

Posts: 2

Join Date: March 11, 2012

Recent Posts

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
March 11, 2012 3:19 PM
Answer

James Falkner

Community Moderator

Rank: Liferay Legend

Posts: 1406

Join Date: September 17, 2010

Recent Posts

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
March 11, 2012 8:01 PM
Answer

Vishal Verma

Rank: New Member

Posts: 2

Join Date: March 11, 2012

Recent Posts

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.