Row Limits - Dashlets and Reports

**rwieler** · 2010-02-09, 09:47 PM

Hello, I have been trying to find some information in the forums regarding row limits for reports and dashlets. I have seen some posts that discuss the query limit that is managed in the config.php, but I can't imagine it is limitless. Any ideas on the constraints of the application in this regard?

Thanks in advance for the assistance.

Regards,

RW

**jjwdesign** · 2010-02-09, 10:10 PM

I imagine PHP might eventually run out of memory if you have hundreds of thousands of records. I've got some custom Tracker reports that output around 10,000 items (max). The page can actually load, but it's extremely slow. There's probably a limit on the browsers ability to display the HTMl as well.

But, with most of my typical modules I limit the number of rows displayed at a time to 25, 50 or 100. Why do you ask?

Jeff

**rwieler** · 2010-02-09, 10:18 PM

We are working with a client on an SFDC migration, and they have a dashlet equivalent that shows a list of open incidents by account (over 100 accounts). They want to replicate this function. We have discussed alternatives, but they want to keep this.

From a reporting perspective they have asked about the row limit, and I am looking to identify if one exists. Some apps I have worked with have hard limits built in ensure performance, just curious.

**jjwdesign** · 2010-02-10, 02:37 AM

From what I've seen, it's fairly unlimited by the App, since you can write your own custom modules/controller/views/etc. Custom dashlets can give you more functionality. The existing dashlet code can be tweaked as needed.

If they are viewing an account's detail view, then they'll usually have access to the subpanels. Those subpanels (cases, notes, etc.) can be fairly flexible as well. As far as number of records in MySQL tables, I find MySQL InnoDB tables to be the best performance (for free). I've had 140,000 targets/prospects in database table. I've also pushed 1GB for an email data table. That's one area where the OS file size limit would place a maximum to the number of records; 4GB on a Unix system - if I recall correctly.

Cheers, Jeff