Charlotte Foust
cfoust at infostatsystems.com
Tue Jul 13 15:12:48 CDT 2004
I'm pretty careful about that. Some of our previous developers relied
on the built-in garbage collection (LOL) but I don't ever assume objects
will go out of scope when they should. I always destroy them
explicitly. Every place I find something like that, I fix it, so I
don't think that's the problem. Besides, I don't think that would cause
a *sudden* memory spike. We aren't automating another application, we
call into dlls for extended functionality like creating the PDF files.
The only recursive code in the whole blasted app is some callbacks to
populate comboboxes, so I don't think that's it either.
Charlotte Foust
-----Original Message-----
From: Dan Waters [mailto:dwaters at usinternet.com]
Sent: Tuesday, July 13, 2004 10:56 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Out of Memory problems - AXP/WinXP
Charlotte,
I remember that when an application is opened by automation it is
sometimes not visible. For example if I open Excel from Access and I
want to see the spreadsheet on screen, I have to explicitly set a
visible property to true.
Could your code be recursively opening objects but not closing them? I
guess this would apply to applications, recordsets, queries, and other
things too.
I'm just trying to save the wall ;-)
Dan Waters
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, July 13, 2004 12:08 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Out of Memory problems - AXP/WinXP
We aren't testing the print part at this point, only email and PDF file
distribution. Of course, the PDF driver is a printer, but we're stuck
there. All the machines we're testing are Dells and we can't really
switch video cards easily, but I'll keep it in mind as a last resort.
I'm fixating on the video cards because it seems like the only
explanation left. Actually, at least one of the machines with poor
performance has additional on-board memory on the video card. That
knocking you hear is my head beating againt the wall. ;-{
Charlotte Foust
-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Tuesday, July 13, 2004 8:39 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Out of Memory problems - AXP/WinXP
Hi Charlotte
You mention it yourself. It could be the video driver. Or the printer
driver.
If used for nothing else than running your reporting engine, try
switching to plain VGA or SVGA or switch to a proven video card like
Matrox or ATI.
Also check the printer drivers. If printing via PCL try switching to
Postscript.
I'm have an app like this in my plans (and so did Steve?) and would be
very interested if you could report back your findings.
/gustav
> I'm wracking my brains to figure out why an AXP application of ours
> exhibits different behavior on different but similar machines. We
> have an app that simply sits there and distributes reports, either by
> email, to a printer or to PDF files. It operates on a timer and
> checks to see if new data has been received. If it has, it checks the
> distributions configured and sends the reports. The baffling thing is
> that at some point, we get a "not enough memory" error that brings it
> to a halt. The brute force method is to shut the thing down and
> restart it. We could even do that automatically, but the trouble is
> we can't figure out what causes it. It does not appear to be memory
> leak and we've tried everything we can think of: tweaking the virtual
> memory, turning off file indexing, changing the interval, updating the
> jet service pack to 8, etc. It is very consistent on each machine,
but the machines we can
> test it on don't fall over at the same point. The best performance
> comes from the machine with the least RAM, the oldest video card and
> the slowest processor, but all are running WinXP SP-1 and OXP SP-2.
> All the machines are P-4s, have 40GB HD and have some flavor of NVIDIA
> Getforce2 adapters. The best performance is coming from the 256 MB
> RAM machine with a 1.50 Ghz CPU.
> I'm tearing my hair out in handfuls, and I can't find a clue anywhere
> I've looked. Can anyone shed any light on this?
> Charlotte Foust
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com