EBDN - Community - Question & Answers
0
Undo
Votes
Hello,
I have developed a EB VBA application to create labels file for electrical project to release to our PLM system with the EB project.
I was wondering that this VBA routine, which is recursively scanning all the objects in the Equipment folder, is running in 2 ways:
in the first run, the routine is consuming about 120 sec on a project to create the output of all the labels, if I run again the same routine on the same project the time needed to create the output is about 15 or 20 sec, which is a time completely different from the first run.
I'm assuming that the first run creates a kind of cached data, that will greatly influence the second run because the data are cached in memory and there is no need to read them back from the db.
I was wondering if this kind of cache strategy that seems to be implemented in EB could be used at programming level.
My idea is this: If a run a read of a project of all the items (devices and cables) and create in this way the cached data, the run of the routine to produce the labels would be more faster.
Could someone of Aucotec answer this question or give me an programming example if this strategy is correct ?
Waiting for a reply, best regards
Franco Silveri
I have developed a EB VBA application to create labels file for electrical project to release to our PLM system with the EB project.
I was wondering that this VBA routine, which is recursively scanning all the objects in the Equipment folder, is running in 2 ways:
in the first run, the routine is consuming about 120 sec on a project to create the output of all the labels, if I run again the same routine on the same project the time needed to create the output is about 15 or 20 sec, which is a time completely different from the first run.
I'm assuming that the first run creates a kind of cached data, that will greatly influence the second run because the data are cached in memory and there is no need to read them back from the db.
I was wondering if this kind of cache strategy that seems to be implemented in EB could be used at programming level.
My idea is this: If a run a read of a project of all the items (devices and cables) and create in this way the cached data, the run of the routine to produce the labels would be more faster.
Could someone of Aucotec answer this question or give me an programming example if this strategy is correct ?
Waiting for a reply, best regards
Franco Silveri