PDA

View Full Version : savepoint



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;

Sarek
04-23-2011, 12:36 PM
Please create new database and try in it.

tund3r
04-23-2011, 01:18 PM
Please create new database and try in it.

then how to import all the data in this database without import the errors (if there are)

fozzy71
04-23-2011, 09:38 PM
then how to import all the data in this database without import the errors (if there are)

By importing all the original hands to the new database.

Make sure windows is fully updated and change your Windows Control Panel > Regional Settings Format to English (USA).

Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands

Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

http://faq.holdemmanager.com/questions/119/Warning:+You+have+XXX+Hand+History+Files+in+your+A uto+Import+Folders

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).


*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips