PDA

View Full Version : Decrease size of database?



Radish
02-15-2010, 07:35 PM
hi,

my database is already over 130gb big and fairly slow. i started to purge older datamined hands which didn t help me to increase my free hd space.

whats the best way to decrease the size of an current database and whats best to keep the database fairly small if you are importing about 100k datamined hands every day?

Patvs
02-15-2010, 09:56 PM
Check out the top 10 performance tips thread in my signature.

Especially: deleting logfiles, vacuum/analyse + reindex + purge, etc.