Recently we had an AyaNova user contact us because creating a new workorder or opening an existing workorder would take about20 to 30 seconds to open to see the workorder entry screen.
Determined that they had over 32,000+ parts imported into their AyaNova Firebird Server database - of which they are actually using only about 2000.
When a workorder entry screen opens (whether creating a new workorder or editing an existing), AyaNova pre-loads the list of potential parts you might select.
Because this company had so many parts, it takes time to list all of them in the workorder.
Recommendations:
-
Change to a SQL database configuration. SQL can handle more data than Firebird Server can. Do note though that SQL has higher hardware requirements than Firebird Server, so do check on a regular basis how your server is handling (CPU, memory, etc)
-
Delete (or set inactive) parts that you do not use to minimize the list of parts retrieved.
Take advantage of the example report template at http://forum.ayanova.com/Topic4758-103-1.aspxto get a list of parts you have actually used in workorders.
- Joyce