Hi Keith I remember this setting existed back in the times of eDeveloper, but since it was never documented for XPA versions, I assumed it had been replaced by the mgdebug option. I

Avgerinos, This is not Magic Debug. It’s called the Magic Profiler and requires you to set a Windows Environment variable of MGPROF=1 for it to work and generates two files with performance

Keith and Frederik Yes, the magic debug log was one of the the first I though, but I did not have much luck at this time: The programs have to run for 1-2 hours (or to be

Hi, Avgerinos, I assume Keith means the magic profiling that can be activated via Windows environment variables: look up the "MGPROF" setting on this group, it has been mentioned some times before,

Hi Keith Are you referring to the MSSQL Profiler? Because the problem exists even with calculation-subtasks that are not accessing any database Regards Avgerinos On

Avgerinos, Have you turned on the Profiler rather than using the mTime function inside the application? The Profiler for the most part has almost no “drag” on the application, yet can track

Thank you Andreas. A memory possible leak was one of my first suspicions. But from what I can see in the task manager, only a very small increase in memory usage can be noticed after

Hi Steven Thank you for your reply, this would be the first time for me to install Pervasive/Actian Zen, and i'm not sure of goldstar team would actually assist us to the point of connecting it to

Marwin, I would recommend at least v13, if not the latest version, v14 (released in August), and definitely 64-bit. The product has been rebranded as Actian Zen in v14, but it's fully

Hi Magic u/l group: 1) our current setup is we are using Pervasive SQL v8.10 in a Virtual Server running Windows Server 2003 2) We are using Unipaas 1.9C in separate Windows Server 2003 32bit /

would declaring the tables help, or is using declares in the parent task just a way to speed files opening in parent tasks so it doesnt have to open them over and over as the subtasks run. I defer to

Thank You very much Todd Best regards,

Hi Avgerinos, Sounds like a memory leak in Xpa to me what you describe. Did you monitor memory usage of your process ? You can do that f.i. with Windows Performance Monitor

Hi Avgerinos, Alas, I cannot confirm or deny your last question with any absolute certainty. If I were you I would check every tasks' transaction settings, including the one on top that is calling the

Thank you Frederik I will try. Do you think transaction settings may affect execution of tasks that are not accessing any database tables? Regards Avgerinos On

Marc, In magic.ini LoadResidentFiles = Y Todd On 10/28/2019 1:25 PM, Marc Gauthier wrote:

Hi, Avgerinos, I have seen something like what you describe. In my case I was importing text files into memory tables, and the process of running my program seemed to take more and more time, although

Hi, Anybody was able to make the Resident option with the DBMS Btrieve ? I'm using XPA 3.2e I'm trying to get a small table to be resident. But according to the Monitor (PSQL Control Center Monitor)

Yes, I thought of this already: tried boosting magic's priority but it does not affect execution time at all On 28/10/2019 6:31 μ.μ., Jeroen Bos via Groups.Io wrote:

Just a thought, can it be that the program gets a lower execution priority or maybe that the program memory is replaced to the virtual memory? Met vriendelijke groet / Yours sincerely Jeroen