PDA

View Full Version : trouble displaying hands



bg26892
06-12-2009, 08:44 AM
My db is VERY slow in retrieving and displaying hands...

I vacuum and analyze my DB religiously.
I am using 1.09.4 beta.
DB is roughly 2 gbs.

I have removed nearly half of the hand view columns in an effort to speed things up.

Please advise.

Thanks!

fabio
06-12-2009, 09:58 AM
try a reindex via pgAdmin and defrag your harddrive while the postgresql service is stopped

bg26892
06-12-2009, 11:50 AM
try a reindex via pgAdmin and defrag your harddrive while the postgresql service is stopped

did both and i'm still getting the msg about "the retrieval of hands seems to be running slow"

fabio
06-12-2009, 12:04 PM
did you remove the 3 WInnerxx under hand view columns?

bg26892
06-12-2009, 12:37 PM
once i removed all 3 it worked super quick. however, i had been using all 3 of these column selections for several months without an issue until the last update.

i would still like to use some of these 3 filters...which of them is the most memory intensive?

thanks!

fabio
06-12-2009, 01:41 PM
those are no filters, they just tell you who won the hand in the reports tab

seat3ismine
06-12-2009, 01:48 PM
did you remove the 3 WInnerxx under hand view columns?

mine runs quite slow too. how do i remove these?

bg26892
06-12-2009, 03:24 PM
mine runs quite slow too. how do i remove these?

OPTIONS menu

Hand View Column Selection

bg26892
06-12-2009, 03:25 PM
those are no filters, they just tell you who won the hand in the reports tab

ok then which of them are the most memory intensive? ideally i would like to keep most of them but understand that the more i keep the slower it will run.

seat3ismine
06-12-2009, 03:30 PM
OPTIONS menu

Hand View Column Selection

on the left hand tab there are ALOT of things, do i remove them?

fabio
06-12-2009, 04:30 PM
Only remove WinnerName WinnerCards and WinnerWon, those are the most memory intensive