Tanks Ann. Em 21/08/2013 16:55, Ann Harrison escreveu: > > On Aug 20, 2013, at 7:14 PM, Hugo Eyng <[email protected] > <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]
