Running Large VLE

Comments

• bbrown Member Posts: 3,268

  2010-09-15

  Why do they want to run it from Object Designer? Object Designer is not an end user tool. It's a developer tool. Whenever a customer feels they need to run something from Object Designer, that should be a huge flag that there's something missing. Either in terms of system business process design or user training.
  
  What do you consider huge?

  There are no bugs - only undocumented features.

  0
• ryanatwork Member Posts: 47

  2010-09-15

  Cannot remember the exact number of records. The size is somewhere around 5GB - total database size is +- 100GB.
  
  (from memory) on another VPN now so I can't check

  0
• bbrown Member Posts: 3,268

  2010-09-15

  One site I work with has 80 million VLE records (and growing). DB is north of 300 GB.

  There are no bugs - only undocumented features.

  0
• Shedman Member Posts: 194

  2010-09-15

  Is there an appropriate key selected for the fields they are filtering on? Or does running the table already hang the system.
  
  Probably the best option you have is to create a form that is sorted by their most used key by default. And tell them to select the right key before filtering on some other field.

  0
• rhpnt Member Posts: 688

  2010-09-15

  ryanatwork wrote:

  The solution that I have here is to drop a Form with a few fields for filters over the table and then allow the customer to search it that way.

  
  Instead of doing that consider implementing a BI system that queries the data in its own tables. You don't want to clog up the NAV table with queries while others try to post purchase invoices. Try BI4Dynamics its cheap and simple to implement.

  0