Al-Raaya Mughlai Restaurant, Mehmood Qasoori Road, Gulberg, Lahore
I thought to start posting about restaurants where, either I had a chance to dine or plan to. So here is one to begin with. Recently Chalo.pk has launched a deal with 52% off. The deal is for 4 and main course includes: Pappudum (Starters) Murgh Chaska Curry Chilman Gola Kabab (6 pcs) Rashmi Boti […]
Performance Targets and Indicators
Hi Mates.. Need your input on one thing. One of our customer is referring to NetSol “performance testing plan” and “performance target and indicator”. Can you please help to understand his requirements from NetSol and do we have any template for Performance Plan and Performance targets.. This post was viewed (64) times.
Avoid functions returning tables
In queries which returns large data set don’t use table return type function in main query join part. It contribute in increasing of query execution time. The solution is to make the temporary table from the function and created the index on joining fields with main query. This improve the significant time of main query […]
Fasting incentive for Muneeb Kayani
This is 3rd Ramadan today and as we know, Muneeb has already missed out 2 fasts. Today he has his first fast on the go. To encourage him for further fasting, we (the Test Automation team) has decided to offer him a series of incentives; below are details: Total 28 Fasts makes him win: Dinner […]
Avoid VIEWs in queries returning large data sets
In queries which returns large data set, avoid using complicated views in main query join part. It contribute in increasing of query execution time. The solution is to make the temporary table from the complicated views and created the index on joining fields with main query. This improve the significant time of main query execution. […]
VUGen in LoadRunner
The Virtual User Generator (VuGen) is used to simulate the steps of real human users. VuGen can also run scripts for debugging. VuGen lets the user record and/or script a test to be performed against an application under test, and play back and make modifications to the script as needed, such as defining Parameterization (selecting […]
Non functional history triggers can be disabled while executing dayend to optimize the process
During day end optimization for MBAFC we disabled history triggers on contract table to optimize day end procedure “SP_dayend_upd_od_daysâ€ÂÂ. This change reduced the 5 minutes of procedure execution time. This post was viewed (38) times.
Cursor impact on Performance
Cursor usage should be avoided in procedures, functions and triggers. But if in some situations can’t be avoided then there is one important tip is for maximum performance. This is that cursor definition query should be kept simple as possible. The multiple tables joins and filters should not be used in cursor query. In below […]
Corrupt Connectsions
Is it possible that some of the connections (at EA Server) in the connection pool are corrupt for some reason, so when the application try to use these connections to execute SQL, the error of invalid handle will be thrown? This post was viewed (52) times.
Default number of connections in the connection pool?
Connection pool of EA Server , by default, is set to 30 and we at NetSol are using default properties in most of implementations. This post was viewed (32) times.