PAHud: long is the cache update taking

Сообщение от APerfect10

If your cache is slow to update here is something you can do to speed it up. Josh, you should really implement this.

My PAH's cache size on disk is in the 3MB - 4MB range. By default, SQLite only caches 1000 pages and each page is equivalent to 1KB. Therefore its only caching ~1MB or 1/4 of the database. Today's computers have plenty of RAM so its quicker to cache the entire database rather than read/write to disk each transaction. So lets update the default cache size to 10000 to ensure that we're updating through your fast RAM rather than your slow hard drive.

[Зарегистрироваться?] is the nicest admin tool available. Download and run it.

Browse to your PokerAce Software install directory /Data/Temp and open DBCache*.db

Now navigate to this directory via My Computer or Windows Explorer. Locate the DBCache*.db file and determine its size. The filesize will probably be in KB. 1000 KB ~= 1 MB. So if your cache size says 5,388 KB. Your cache is 5.38 MB.

THe default cache size you set should be your cache size in MB * 1000. (Following the example above, my cache size should be a minimum of 5.38 * 1000 = 5380) Lets set it a little higher to allow growth.

Copy "PRAGMA default_cache_size = ##" into the SQL Query window (where ## is the default cache size calculated above.

Find the Query dropdown menu and click "Execute without Result".

This only needs to be done once for your database. If you ever delete the cache and recreate the database then you will need to rerun this query. Hopefully Josh will listen and add the SQL to his database creation code by then.

This has substantially increased my cache update times!

Best regards,

APerfect10