Skip to Content
author's profile photo Former Member
0
Former Member

Complex table rowcounts

Posted on Dec 09, 2014 at 05:26 AM 26 Views

Hi All,

I am curious to find out what sort of row counts have been experienced as working in the wild for SAP Work Manager. (6.x)

We have a project running here in Australia for a large Utilities company who have a very large and in some cases very dense (geographically) asset inventory.

For the Functional Location and Equipment complex tables this poses us some challenges as there doesn't seem to be any really good way of limiting these datasets down to what I expect are workable levels on individual devices.

We are going with recent Apple iPads as our mobile device platform so size shouldn't be a problem from a straight storage perspective. My main concerns are around performance of the app (if I have large numbers of records in these tables) and synchronisation times.

Anyone out there willing to share their experiences?

Regards

Marty

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Jason Latko
    Jason Latko
    Posted on Dec 09, 2014 at 02:24 PM
    1

    Marty,

    How large a dataset are you talking about per complex table? Tens of thousands are common. Hundreds of thousands should also be OK on a smart device. Millions of rows in a table might be a problem.

    Jason Latko - Senior Product Developer at SAP

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 09, 2014 at 10:28 PM

      Hi Jason,

      Thanks for the reply.

      We don't have any tables where we expect millions of records. The worst at the moment looks to be ctEquipment at around 750k for the largest region.

      Are there examples of this sort of size working in production on the iPad?

      I'm assuming that the problems would be twofold:

      1. Time needed to synchronise

      2. The performance of the application with that many records

      The business has processes in place where the functional location and equipment data does experience a fair amount of regular change. This is driven by automation from their GIS system. There is analysis underway right now to try and quantify this but if the delta on these two tables is large then synchronisation times could well blow out.

      I am getting the feeling, from your post and some others I have spoken with, that a modern tablet like the iPad should be able to handle table sizes in the order of what we are dealing with. Certainly with 64GB of storage available we should be able to fit the data. There is still some question in my mind an the performance if screens, dropdown lists etc. It would be very nice to get some sort of confirmation on this.

      Should we be considering pre-caching the data somehow in order to minimise these sync times? It would seem to be that the majority of the time spent during the synchronisation is due to the complex rules being applied for the selection of records (BAPI / ABAP execution time). Actual transmission (WiFi or 4G) would appear to account for a relatively small component of the overall sync time.

      Regards

      Marty

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 01:10 AM
    1

    Hi All,

    Can anyone out there give me an idea of your max record sizes?

    Work Manager on iOS would be best.

    I really need to get an idea of whether our current estimated record sets (Max 460,000 records in ctLocations) for a given region is going to be doable. Jason indicates that is should be possible in his post but I'd really like to be able to hear from someone that has done this with an big dataset.

    thanks in advance.

    Regards

    Marty

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Michael Appleby
      Dec 16, 2014 at 10:13 PM

      Hi Mike,

      Thanks for the follow-up. Anecdotal would be fine.

      We are currently in the position of having to choose either going with a vastly reduced dataset and limiting the Notification create functionality (as we won't have all assets available to select) or coming up with a completely custom solution to limit the data to that which is in a close proximity to the Work Orders that the user will have on their devices.

      As you can imagine the work-around in order to get this second option to work is potentially very significant in terms of development time as we would need to determine the work orders for a user prior to the Complex Table synchronisation. This is certainly 'clunky' when compared to the way that Work Manager is supposed to function.

      The new functionality in 6.2 around being able to search for an asset by way of a fetch breaks our core requirement of being able to operate in an offline mode.

      Ideally I'd love to hear that someone has successfully run a production system where the ctLocation and ctEquipment tables each have in the order of half a million records. Delta on either table could be up to 5% for a given sync due to the fact that we are getting updates into SAP from the GIS system each night.

      Can anyone indicate if this scenario is feasible?

      Regards

      Marty

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.