Results 1 to 4 of 4

Thread: Row Limits - Dashlets and Reports

  1. #1
    rwieler is offline Junior Member
    Join Date
    Mar 2008
    Location
    Southern CA USA
    Posts
    3

    Default Row Limits - Dashlets and Reports

    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

  2. #2
    jjwdesign's Avatar
    jjwdesign is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Orlando, FL
    Posts
    503

    Default Re: Row Limits - Dashlets and Reports

    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
    SugarForge Projects:
    JJWDesign Google Maps
    JJWDesign Tools and Reports

    Follow my blog postings at JJW Design.

  3. #3
    rwieler is offline Junior Member
    Join Date
    Mar 2008
    Location
    Southern CA USA
    Posts
    3

    Default Re: Row Limits - Dashlets and Reports

    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.

  4. #4
    jjwdesign's Avatar
    jjwdesign is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Orlando, FL
    Posts
    503

    Default Re: Row Limits - Dashlets and Reports

    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
    SugarForge Projects:
    JJWDesign Google Maps
    JJWDesign Tools and Reports

    Follow my blog postings at JJW Design.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 2011-01-12, 10:29 AM
  2. Enforcing limits on associated items from Custom module
    By dantrainor in forum Developer Help
    Replies: 1
    Last Post: 2010-01-11, 10:53 AM
  3. CSV Import Limits?
    By bogusman in forum General Discussion
    Replies: 2
    Last Post: 2009-10-14, 09:55 AM
  4. Limits?
    By jono in forum General Discussion
    Replies: 3
    Last Post: 2007-07-12, 07:57 AM
  5. Detail view limits & thresholds
    By dmodde in forum General Discussion
    Replies: 1
    Last Post: 2005-04-21, 01:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •