PDA

View Full Version : Player 'Default stats' report error



muppetpower
07-09-2009, 05:11 PM
When running the default stats report for players with 1+ hand from FT over a wide date range I get the error attached after a long (15-20 min) delay.

My database has 276k players, and I'd expect this report to produce 100k-150k rows.

I'm running the latest beta although this error has been around for longer (I just haven't got around to reporting it)

(report used to complete in around 10 mins with a database of 200k players)

Rvg72
07-09-2009, 07:43 PM
When running the default stats report for players with 1+ hand from FT over a wide date range I get the error attached after a long (15-20 min) delay.

My database has 276k players, and I'd expect this report to produce 100k-150k rows.

I'm running the latest beta although this error has been around for longer (I just haven't got around to reporting it)

(report used to complete in around 10 mins with a database of 200k players)

Have you tried a full vacuum? You might also want to go into DBControlPanel and rebuild all the indexes that starts with the name "Compiled"

muppetpower
07-09-2009, 08:30 PM
i'll give that a try. thanks.

muppetpower
07-10-2009, 07:33 AM
The full vacuum did the trick.

Thanks

fozzy71
07-10-2009, 08:54 AM
The full vacuum did the trick.

Thanks

You may want to do a full round of DB maintenance and performance improvements. This thread has lots of great info and tips - http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613