Re: Memory Hog

From: Edgar Binder (edgar_at_softyx.com)
Date: 10/10/03 

Date: Fri, 10 Oct 2003 10:17:28 +0200

Hi,

George Christoforakis wrote:

> Usually this is normal. I guess that 40Mbs are the large ones, eh?

   Yep, that's correct :-)

> The best way to reduce the size is to open the tables on demand, especially if you
> have tables which are rather inactive for a long period of time during use
> of the program. Do you really need all the tables open?

   Nope, but I do need to have all the large tables open.

> Also, to change some of the tables which are mainly for display only, to
> queries, will get your memory in order.

   Yes, that's a good ideea, will do (thank you).

> Check the properties of the tables. Cache size, loads things on memory...
> but I guess this is while using the table... but I'm not really sure.

   I tried a lot of property combinations, none of them reduced my memory usage.
What I didn't succced though ist setting a server cursor, the program complained
of the driver not supporting filtering and so on...

   I'm also playing with the idea of splitting the large physical tables in the
database, because sometimes I only need a fraction of their data. Is this a good
ideea (speedwise), or should I stick with queries? 

--
Edgar

Relevant Pages

  • Re: FTS query performance on SQL 2005
    ... I have achieved a breakthrough in this performance testing, ... of my queries return in under 1/2 second. ... of cached query results. ... memory usage was steadily increasing. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTS query performance on SQL 2005
    ... road and see is you still have optimal performance. ... effects of cached query results. ... queries, the memory usage was steadily increasing. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Memory limitations for Process
    ... > I have few queries regarding the parameters associated with processes on ... I would like to know if there is any limitations on memory usage ... > know the memory usage of the process and available free memory. ... > Any help in this regard is most appreciated ...
    (comp.os.vms)