Tanks Ann.

Em 21/08/2013 16:55, Ann Harrison escreveu:

>
> On Aug 20, 2013, at 7:14 PM, Hugo Eyng <hugoeyng@...
> <mailto:hugoeyng%40msn.com>> wrote:
>
> >
> > Something like: "If I have a lot of RAM available, how could I use
> it in
> > a way to increase the database speed (specially queries)".
> >
> > I found out that chaging DefaultDbCachePages from 75 to 750 the queries
> > really run faster.
> >
> > Using a ram disk drive increases a query that uses ORDER BY or GROUP BY
>
> If your default cache size is 75, then you're not using SuperServer
> with its shared cache. Even with a cache per process, 75 is very small
> for a modern machine. In general, database cache is a good place to
> use memory. A RAM disk for temp space will help when the query
> requires sorting (order by, group by, distinct) but not much otherwise.
>
> Good luck,
>
> Ann
>
>

--


Atenciosamente,

Hugo Eyng



[Non-text portions of this message have been removed]