Page 1 of 1

PT2 imports hands extemely slowly

PostPosted: Sun Nov 29, 2009 8:00 pm
by cool32steve
I converted my database to PostgreSQL, and since the hands import extremely slowly. I found a file with only one hand in it, and it took 17 minutes to import. What can I do?

Re: PT2 imports hands extemely slowly

PostPosted: Mon Nov 30, 2009 8:20 am
by ptrack pat
Use the Utilities > PostgreSQL Database Functions window to do a full vacuum/analyze.

Re: PT2 imports hands extemely slowly

PostPosted: Mon Nov 30, 2009 8:48 pm
by cool32steve
I will try this, thanks!

Re: PT2 imports hands extemely slowly

PostPosted: Tue Dec 01, 2009 10:26 pm
by cool32steve
I tried 2 full vacuum/analyze, and it still takes over 1 hour to import 100 hands. Anything else I can try?

Re: PT2 imports hands extemely slowly

PostPosted: Wed Dec 02, 2009 12:23 am
by ptrack pat
Are you sure the "Auto-rate on import" box is not checked when you try to import hands? If it's not then it sounds like their is an index problem in that the database didn't fully convert so you should try converting the Access database again and make sure that you check the status after it's done to make sure it converted without errors.

Re: PT2 imports hands extemely slowly

PostPosted: Wed Dec 02, 2009 2:09 pm
by cool32steve
Uh-oh... The first thing I tried to correct this issue was to delete the old database, thinking that there may be some conflict... Oh well, at least I have all my hand histories saved on CD... Thanks as always for the support!