How long should it take to purge sessions?

[Leewah]

I know this topic has a high number of variables but I was wondering roughly how long it should take to purge sessions from PT3.

My system specs are:

Model Name: MacBook Pro
Model Identifier: MacBookPro5,2
Processor Name: Intel Core 2 Duo
Processor Speed: 2.66 GHz
Number Of Processors: 1
Total Number Of Cores: 2
L2 Cache: 6 MB
Memory: 4 GB
Bus Speed: 1.07 GHz
Boot ROM Version: MBP52.008E.B05

I've been attempting to purge all cash holdem sessions from 1 Jan 2006 - 31 Dec 2009. I don't know how many sessions there are in there however I also know there cant' be that many because I didn't play that much online poker at the time. I can't imagine there would be more than 250-300 sessions.

Are the logs below indicative of how long it usually takes to purge sessions from my DB? I could be here until Christmas waiting... If you have any suggestions of how I can speed up this process, I would greatly appreciate it.

2011/05/12 11:24:58.705: [- Main -][WindowDialogPurgePanel] Executing: SELECT id_session FROM holdem_table_session_summary WHERE 1=1 AND (date_start >= '2006/01/01 00:00:00' AND date_start <= '2009/12/31 23:59:59')
2011/05/12 11:25:48.566: [B00A1000][QueryReportCtrl] Query 62: Populate: 61841.9720 ms, 422984 rows, 6 cols, 0.0244 ms/col (time log: Query 62: t0: 0.0140 ms, t1: 697.2750 ms, t2: 61144.6530 ms, t3: 0.0010 ms, t4: 0.0000 ms, t5: 0.0070 ms, t6: 0.0050 ms)
2011/05/12 11:32:02.851: [- Main -][ConnectionManager] purgeSession: Total: 423229.6490 ms, GS: 142185.1050 ms, GH: 507.1450 ms, PH: 2055.7030 ms, PS: 157.6490 ms
2011/05/12 11:35:15.915: [- Main -][ConnectionManager] purgeSession: Total: 192385.4800 ms, GS: 92101.0100 ms, GH: 101.6360 ms, PH: 1444.8230 ms, PS: 190.8500 ms
2011/05/12 11:36:57.046: [- Main -][ConnectionManager] purgeSession: Total: 101106.2770 ms, GS: 79317.2030 ms, GH: 141.3680 ms, PH: 5177.1800 ms, PS: 134.7620 ms
2011/05/12 11:38:35.115: [- Main -][ConnectionManager] purgeSession: Total: 98042.6050 ms, GS: 74272.7820 ms, GH: 125.5740 ms, PH: 1108.3060 ms, PS: 620.7060 ms
2011/05/12 11:40:46.591: [- Main -][ConnectionManager] purgeSession: Total: 131251.4560 ms, GS: 108480.5790 ms, GH: 166.9690 ms, PH: 1730.9410 ms, PS: 49.9730 ms
2011/05/12 11:43:06.350: [- Main -][ConnectionManager] purgeSession: Total: 139704.0850 ms, GS: 114699.9190 ms, GH: 174.0010 ms, PH: 1832.3250 ms, PS: 88.7660 ms
2011/05/12 11:45:42.454: [- Main -][ConnectionManager] purgeSession: Total: 156093.8810 ms, GS: 136428.0890 ms, GH: 21.8140 ms, PH: 180.4780 ms, PS: 65.4730 ms
2011/05/12 11:47:28.160: [- Main -][ConnectionManager] purgeSession: Total: 105682.6520 ms, GS: 86279.0940 ms, GH: 29.7760 ms, PH: 143.3120 ms, PS: 23.0850 ms
2011/05/12 11:50:21.341: [- Main -][ConnectionManager] purgeSession: Total: 173116.0150 ms, GS: 138529.2070 ms, GH: 38.4730 ms, PH: 288.8040 ms, PS: 16.9110 ms
2011/05/12 11:54:04.761: [- Main -][ConnectionManager] purgeSession: Total: 223395.3190 ms, GS: 182028.4870 ms, GH: 40.1370 ms, PH: 150.1470 ms, PS: 9.9560 ms
2011/05/12 11:57:19.131: [- Main -][ConnectionManager] purgeSession: Total: 194294.3570 ms, GS: 156437.5390 ms, GH: 96.0260 ms, PH: 359.6170 ms, PS: 9.0030 ms
2011/05/12 12:00:08.442: [- Main -][ConnectionManager] purgeSession: Total: 169284.2420 ms, GS: 135322.1000 ms, GH: 15.6090 ms, PH: 141.0060 ms, PS: 24.0940 ms
2011/05/12 12:02:26.282: [- Main -][ConnectionManager] purgeSession: Total: 137790.2260 ms, GS: 116398.3600 ms, GH: 1.3760 ms, PH: 208.3380 ms, PS: 1.9670 ms
2011/05/12 12:04:07.406: [- Main -][ConnectionManager] purgeSession: Total: 101101.0030 ms, GS: 79810.7000 ms, GH: 24.8590 ms, PH: 102.7390 ms, PS: 16.5800 ms
2011/05/12 12:07:24.550: [- Main -][ConnectionManager] purgeSession: Total: 197105.0970 ms, GS: 168268.8560 ms, GH: 56.1680 ms, PH: 65.3690 ms, PS: 27.6660 ms
2011/05/12 12:09:21.497: [- Main -][ConnectionManager] purgeSession: Total: 116635.0230 ms, GS: 97557.7510 ms, GH: 29.3040 ms, PH: 30.1990 ms, PS: 3.0710 ms
2011/05/12 12:11:11.387: [- Main -][ConnectionManager] purgeSession: Total: 109866.8680 ms, GS: 92550.7610 ms, GH: 25.1670 ms, PH: 44.3750 ms, PS: 4.2110 ms
2011/05/12 12:12:55.735: [- Main -][ConnectionManager] purgeSession: Total: 104314.9680 ms, GS: 85587.2890 ms, GH: 22.3690 ms, PH: 83.8880 ms, PS: 2.5730 ms
2011/05/12 12:14:38.457: [- Main -][ConnectionManager] purgeSession: Total: 102597.8080 ms, GS: 85311.6910 ms, GH: 2.3050 ms, PH: 79.2860 ms, PS: 2.7240 ms
2011/05/12 12:16:25.953: [- Main -][ConnectionManager] purgeSession: Total: 107473.1230 ms, GS: 84948.7880 ms, GH: 14.7750 ms, PH: 26.6650 ms, PS: 1.8920 ms
2011/05/12 12:18:26.561: [- Main -][ConnectionManager] purgeSession: Total: 120354.5470 ms, GS: 103002.4640 ms, GH: 67.8490 ms, PH: 329.6830 ms, PS: 59.9640 ms
2011/05/12 12:20:31.798: [- Main -][ConnectionManager] purgeSession: Total: 125161.5390 ms, GS: 104601.1500 ms, GH: 249.7790 ms, PH: 1577.6230 ms, PS: 195.3340 ms
2011/05/12 12:22:29.773: [- Main -][ConnectionManager] purgeSession: Total: 117972.7000 ms, GS: 97919.7750 ms, GH: 40.3790 ms, PH: 925.5450 ms, PS: 89.8360 ms
2011/05/12 12:24:19.174: [- Main -][ConnectionManager] purgeSession: Total: 109350.2980 ms, GS: 88554.8680 ms, GH: 30.3210 ms, PH: 4224.3470 ms, PS: 42.1710 ms
2011/05/12 12:26:18.554: [- Main -][ConnectionManager] purgeSession: Total: 119359.9600 ms, GS: 97654.4480 ms, GH: 136.6520 ms, PH: 3014.4180 ms, PS: 110.5820 ms
2011/05/12 12:28:17.710: [- Main -][ConnectionManager] purgeSession: Total: 119110.7730 ms, GS: 98441.7770 ms, GH: 69.7710 ms, PH: 1611.8430 ms, PS: 532.5160 ms
2011/05/12 12:30:21.814: [- Main -][ConnectionManager] purgeSession: Total: 124082.1170 ms, GS: 104483.6760 ms, GH: 78.1030 ms, PH: 627.6880 ms, PS: 56.3260 ms
2011/05/12 12:32:10.997: [- Main -][ConnectionManager] purgeSession: Total: 109134.9610 ms, GS: 88298.2530 ms, GH: 122.0500 ms, PH: 1983.5840 ms, PS: 278.9970 ms

[tarix]

You need to upgrade to v3.11. From your logs it seems like you are still running an older version.

[Leewah]

Last time I upgraded to 3.11 on OS X 10.5.8, I couldn't even start PT3.

A support ticket was lodged for this: https://www.pokertracker.com/support/ti ... _id=108784

Can you confirm that 3.11 for OS X has been fixed yet because I was told by you to continue using 3.10 until I was notifed. viewtopic.php?f=16&t=34616

Will upgrading to 3.11 actually speed up the purge times or is there a better solution? I've found that purging sessions take a long time from all my previous PT3 versions, more often than not resulting in a hanging application which I have to force quit.

[WhiteRider]

There is a very significant improvement to purge speed in v3.11, but you're right - that version doesn't work on Mac. You would be better to wait for the next release before doing your purge, if you can wait.

[Leewah]

I guess I can hold out for a little while. Do you have an ETA for release of a working V3.11 for OS X?

[WhiteRider]

I don't at the moment, but I'll try to find out for you.
EDIT: sorry I see you already have a ticket - we'll contact you via that.

[tarix]

You have a fix in a reply to your support ticket.