by pasita » Mon Oct 21, 2013 5:38 am
Not sure if you'd spare time... it does take me 5 minutes to get the info displayed on a full table.
When I run the query in pgl, it takes something like 70 000 to 80 000 ms, ie. 70-80 seconds per person. All these figures are dependent on the size of your db and how many hands you have on the player. (This would take about 20 milliseconds if PT changed the generated query just a bit, in a way that would actually make sense... this would be highly usable at that point.)
All the other stats seem to load first, but I suppose it leaves quite a load in the postgres server, i.e. if you had several tables open, there could be a ton of these queries running and updating in the background. Maybe it wouldn't be a huge issue with HUHU, though.
Also, to get something useful out of this, you'd likely need to be able to do some regexp stuff in the query (the column), or some formatting magic at the stat, don't know which would be easier, depends on your needs.
To make this really useful, you should probably build your own extra hud with AHK or something, you could get the data instantly. Or convince PT to make the fix in the code. Not sure which one would be the easier task.
Anyway, if you're sure you're not about to shoot yourself in the foot AND feel comfortable with regexp and pgadmin (to make the stat really meet your needs) you can contact me via PM, I don't wish to cause a rush to PT support over this.