PDA

View Full Version : Timeout when retrieving all hands from v. large database



AntiMatter
04-03-2012, 03:49 AM
I have migrated to HEM2 some time back. However, I want to kill my old HEM database.... But prior to doing that, I need to view all hands, so that I can confirm that I have them all in my new HEM2 database.

When running a "By Stakes" report on all my hands (like 2 million +) I get the following error: "The following error occurred when running this report: A timeot has occured. If you were establishing a connection, increase Timeot value in ConnectionString. If you were executing a command, increate the CommandTimeot value in ConnectionString or in your NpgsqlCommand object".

I have vacuum/analysed the database. I have copied the command from the Logs/SQLErrors folder and run it through the query tool in PostgreSQL admin. However, this is not formatted all nicely like with HEM.

Is there some way to increase the Timeout value? I am happy for the command to take all night!

Thanks.

netsrak
04-03-2012, 04:24 AM
Sorry but its not possible to modify this parameter. You should review your hands in smaller portions.