Re: Why does Poker Tracker have to be so [censored] slow?
[ QUOTE ]
I think the main problem with PT is that their is some fundamental problem with it's design (either in it's schema or in the use of PowerBuilder code for it's parsers).
[/ QUOTE ]
It appears that there is a leak in their code, I think they are not po0ling their db connections or not releasing them them somehow. There is a limit where it just hits a wall and db connections and memory goes up and performance goes down, but I haven't really figured it out since i cant do anything about it anyways.
The schema's allright, a few little things that get into any software, especialy when you figure they added on sites and functionality with upgrades.
There are lots Id do differently, but when I look at any db that I designed, by the time I get to release, Id say the same thing. BUT if just a few indexes and constraints were added i think it would help a lot, but you would have to know the exact t-sql the PT client uses.
enough ramblings .. thanks juk for the link (again)
|