How to measure SQL hits due to my application
Use case: I'm working on a form in development environment and everything works fine. aqPerformance tells me everything is quick. I make a change in my form. aqPerformance still tells me everything is quick. Users suddenly report that everything has slowed down and the system is unusable and they want me to personally drive over to their offices and make coffee while they wait for the form to load. After testing, I find that the small change in my form suddenly added 200 SQL queries each time you move your mouse. This isn't a problem in production or our test servers, but the users are on a network with high latency. Each single SQL connection is quick, but it adds up. Is there a way to monitor these SQL hits by, say, using profiler and profiling during the form load/ item select etc. then report back the amount of SQL queries ? I know developers could keep profiler open while developing the application, but sometimes it doesn't behave the same on you machine as on live and you want to know if something has dramatically changed. Also, if you could catch this before it gets to users that would save alot of fuel.
Advanced TestComplete SmartBear Academy class!
Hello everyone! We are really excited for ouradvanced TestComplete 301coming up next week! The class isTestComplete 301: Testing Web-Services with TestComplete(8/29@ 2-3pm ET). If you want to join, register athttps://smartbear.com/academy/ Hope to see you there!TestComplete 11.0 - Memory Issue
Environment Details: Windows 7, 64 Bit, 8 GB RAM TestComplete 11.0 Project Details: Used NameMapping Approach Defined All object references in one script file as Global Variables. There are 3000+ Variables. Reading and Writing Data from Excels Problem: When i open my project. RAM usage is 320-340 MB When i run any of my test function RAM usage will increase to 450-500 MB If i keep on running test functions RAM usage will increase to 800+ MB This is making my test execution go slow and crashing application under test. Anybody faced this kind of issue ? Why RAM usage will be increasing every time ? Is there any memory leakage ? Why after execution RAM usage is not coming to normal ?
After updating my TestComplete 11 my test doubled the runtime
My system: 8GB DDR3 1600Mhz's, i7 - 4790 3.6 Ghz. Windows 7 SP1 x64. Below I put the test code that are having trouble. The test is the test-TC9-TC11.txt file. The log version of TestComplete 9 is attached: versionTC9.mht; The log version of Tescomplete 11 is attached: versionTC11.mht; Files with the description of the test execution duration: CT_2_5117-timeTC9. CT_2_5117-timeTC11. In the code which is bold it is where the problem exists, ie before took the test 50 will be 60 seconds. 90 will now 120 seconds. I am totally disappointed with TestComplete 11 as it needs to compare versions of Delphi 2007 and Delphi xe8 with this problem eventually I lost time. Would there will be a fix for this? I found other posts complaining about something. I do not know if you were all given this issue. But here the total time of all tests end up bringing damage. If anyone knows any extra configuration that TestComplete 11, please. Thank you. Patrick Bremm
