Neotys.com

Unanswered question

SQL datasource

If we attach data source for our scripts as SQl , so during the loadtest from agent how will the script connect to database? and wont the time spend in disk I/O?

Divya K.
Divya K.

Divya K.

Level
1
230 / 750
points
Answer count
4 answers
Category
NeoLoad Runtime
Author name
Divya K.
Date
August 17, 2015
over 9 years ago
Hits
viewed 857 times
question
q

Answers

Patrick Z.
Patrick Z.

Patrick Z.

Level
1
232 / 750
points

NeoLoad will connect to the database before starting the actual test.

Author name
Patrick Z.
Date
answer
a
Divya K.
Divya K.

Divya K.

Level
1
230 / 750
points

So every time it requires data during the run it will fetch data from database?

Author name
Divya K.
Date
answer
a
Patrick Z.
Patrick Z.

Patrick Z.

Level
1
232 / 750
points

No, it only fetches data at the beginning of the test.

Author name
Patrick Z.
Date
answer
a
Nouredine A.

Nouredine A.

Level
4
5000 / 5000
points
Team

Also for your information, you can see the result of your SQL request <your project folder>\SqlTemp folder.

Like Patrick said, the SQL request is fetched during the initialization phase of your test.

Author name
Nouredine A.
Date
answer
a