Player 'Default stats' report error

[muppetpower]

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]

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]

i'll give that a try. thanks.

[muppetpower]

The full vacuum did the trick.

Thanks

[fozzy71]

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/showthre...ed=1#post62613