How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
Answer / rajat
Follow below mentioned steps in order to execute query
through LR script-
(1) Establish conn with DB
lrd_open_connection(&Con1, LRD_DBTYPE_ORACLE, "bb",
"lion", "hammer", "", 0, 0, 0);
(2) Enter query
lrd_stmt(Csr1, "select ename from employee where
(sal>=1000)\n", -1, 1, 1, 0);
(3) lrd_bind_col(Csr1, 1, &D21_ENAME, 0);
(4) Execute query
lrd_exec(Csr1, 0, 0, 0, 0);
(5) lrd_fetch(Csr1, -3, 1, 0, PrintRow24, 0);
(6) lrd_close_cursor(&Csr2, 0);
(7) lrd_close_connection(&Con1, 0, 0);
| Is This Answer Correct ? | 6 Yes | 1 No |
difference between latency and transaction response time
What is Workload? Can anyone explain in detail?
Hi all, I am new to Load Runner. I have run the load runner and i got analyzed reports/graphs. But i am very much confused about how to analyze those graphs. Can any one help me out this problem?
If we want to know the size of each component in system how?
how many performance test scripts have you written? what was the performance issues you had? what did you recommended to that issues? what kind of performance requirements did you have? how did you tune the system for performance? how did you ramped up the users? how did you find the bottlenecks of the system? did you find any coding issues and if yes what kinds of?
How is the Best Faculty for LoadRunner in Hyderabad
what is the 90% ile time in the analysis results?
Explain performance testing life cycle.
Suppose ur app server is .net server. In that connection pool is related to memory ?explain how?
How many section database vuser script have?
we have auto correlation, so why do we need to perform the manual correlation
Do we consider firewall in performance testing? If so where and why and what we will do with firewall in testing?