Asle Frantzen

AFTables and memory usage. Any differences with 1 big query vs. several smaller ones?

Discussion created by Asle Frantzen Champion on Jun 14, 2013
Latest reply on Jun 14, 2013 by Asle Frantzen

We're depending heavily on AFTables to integrate one of our clients' MES system with PI AF, and being that we've already done a few things to decrease the loading time of their ProcessBook displays I would like to know if there is any performance difference (or memory usage differences) with keeping one large table with metadata for multiple types of equipment, compared to splitting it up into different tables with less data in each.

 

My current case involves a ~5000 rows query, where they're distributed 3500/1500 for two different types of equipment.

Outcomes