Hello,
I was looking into the code of InfoWindow and InfoPanel for testCount() method and got few queries,
- Why we have two methods of testCount one in base class and another one in child class? What is the difference between the two
- In InfoPanel testCount method sqlCount query is used which is fast whereas in InfoWindow sqlMain query is used and on top of that count is added which is becoming very slow ? Take the example of Product Info where there are multiple function calls are made for QtyAvailable, QtyOnHand etc
If we dont need two method we can have only one in infoPanel and also query of count should have count only in the select rather having entire main query and adding select count on top of it.
I am not sure what is the reason for this implementation hence I am putting down my query here to get myself in terms of implemented code.
Looking forward for the response for the same.
Thanks,
Pritesh