PT running extremely slow when importing hands

[samuel]

PT is running very slow -- taking ~10 minutes to import 80 hands and slowing down the whole computer.

I do not use auto rate
It's set up to move processed files to a separate folder
I compact the db frequently

Any suggestions?
My OS is Vista if that makes a difference.

[ptrack pat]

Is this just a recent development that this started happening?

Are you sure the "auto-rate on import" box is not checked?

Open the File > Maintain Database Names window and double-click on the name of the database that you are having problems with and it will open a window to tell you the file size and name of the file, what are those?

[samuel]

started last week and has been getting worse. The auto rate is definitely not checked.

db name = ptrack.mdb file size = 2,030,608 -- yikes this seems big.

[ptrack pat]

2gb is the max size of an Access DB so you are soon going to be getting db errors about this.

I would recommend converting to PostgreSQL now...

http://www.pokertracker3.com/forums/archives/PT2/viewtopic.php?t=6310

[samuel]

I've tried to download the postgreSQL but am having trouble.

I'm on Vista and have unchecked the box on UAC as stated.

When I get to the service configuration, I create a password and hit enter it says: "invalid username specified: Logon failure: unknown user name or bad password" Can't get any further than this.

[ptrack pat]

When you get the first prompt that requires you to enter a password, change the user name their to "postgres2" instead of "postgres" and then continue. The second time you get the prompt to enter a password, you should leave the user name set to "postgres".

[samuel]

okay. that worked. now when i try to convert the DB, I get an error

101 - SQLSTATE =08001
FATAL password authentication failed for user
this could be because:
1. entered wrong username / password / server name / port
2. not started the PostgreSQL database server
3. not installed the PostgreSQL ODBC driver

[ptrack pat]

[quotez9t]FATAL password authentication failed for user [/quotez9t]

For what user?? Usually it says a name here.
What settings did you use on the PostgreSQL Settings window? Did you enter "postgres" there for the user name? Are you sure you wrote the right password?

Go to the Start > All Programs > PostgreSQL 8.2 > Edit Config. Files and right-click on Edit pg_hba.conf and select 'run as administrator'. Go to the bottom of the file, change both places where it says "MD5" to say "trust" and save the file and then try it again, doing this will make it not care about passwords.

[samuel]

i changed that. now when i try to convert it says:

Error connecting to the default PostgreSQL database
101 - SQLSTATE 08001
could not translate host name "postgres" to address: unknown host

This could be because you have...
1. entered the wrong user name / password / server name / port
2. not started the PostgreSQL database server
3. Not installed the PostgreSQL ODBC driver

[ptrack pat]

Open the Utilities > PostgreSQL Settings window.

On this window, if you used the defaults when installing then you should have

port = 5432
server = localhost
username = postgres
ODBC Entry = PostgreSQL Unicode
Encoding = UNICODE

Is this what you have? If not, you need to change the values, save it and try again.