tund3r
04-23-2011, 11:52 AM
Hi,
i noticed that the import hand history was very very slow, less than 0.2 hands / second
than i activate the database trace to see if there was some difficoult query or other and i noticed that every hand it imports, start a loop with the rollback, after the first 2 lines that i suppore are the finish of the insert start the
HM COMMAND: SAVEPOINT beforegame;
HM COMMAND: ROLLBACK TO SAVEPOINT beforegame;
HM COMMAND: RELEASE SAVEPOINT beforegame;
loop sometimes for over a minute
this the log:
04/23/11 17:45:37 HM COMMAND: EXECUTE PlayersInsert (1,'rqz2141508',0,0,to_timestamp('01/01/2000','MM/DD/YYYY HH24:MI:SS'),0); select currval('players_player_ID_seq')
04/23/11 17:45:37 HM COMMAND: EXECUTE PlayersInsert (1,'lza915610',0,0,to_timestamp('01/01/2000','MM/DD/YYYY HH24:MI:SS'),0); select currval('players_player_ID_seq')
04/23/11 17:45:37 HM COMMAND: SAVEPOINT beforegame;
04/23/11 17:45:37 HM COMMAND: ROLLBACK TO SAVEPOINT beforegame;
04/23/11 17:45:38 HM COMMAND: RELEASE SAVEPOINT beforegame;
04/23/11 17:45:38 HM COMMAND: SAVEPOINT beforegame;
i noticed that the import hand history was very very slow, less than 0.2 hands / second
than i activate the database trace to see if there was some difficoult query or other and i noticed that every hand it imports, start a loop with the rollback, after the first 2 lines that i suppore are the finish of the insert start the
HM COMMAND: SAVEPOINT beforegame;
HM COMMAND: ROLLBACK TO SAVEPOINT beforegame;
HM COMMAND: RELEASE SAVEPOINT beforegame;
loop sometimes for over a minute
this the log:
04/23/11 17:45:37 HM COMMAND: EXECUTE PlayersInsert (1,'rqz2141508',0,0,to_timestamp('01/01/2000','MM/DD/YYYY HH24:MI:SS'),0); select currval('players_player_ID_seq')
04/23/11 17:45:37 HM COMMAND: EXECUTE PlayersInsert (1,'lza915610',0,0,to_timestamp('01/01/2000','MM/DD/YYYY HH24:MI:SS'),0); select currval('players_player_ID_seq')
04/23/11 17:45:37 HM COMMAND: SAVEPOINT beforegame;
04/23/11 17:45:37 HM COMMAND: ROLLBACK TO SAVEPOINT beforegame;
04/23/11 17:45:38 HM COMMAND: RELEASE SAVEPOINT beforegame;
04/23/11 17:45:38 HM COMMAND: SAVEPOINT beforegame;