On Aug 20, 2013, at 7:14 PM, Hugo Eyng <[email protected]> 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
