|
 |
Q1 |
What is the structure of the table TG uses to send queries on the database server? |
 |
A1 |
TG doesn't have particular tables to send queries. This is the spec of TG.
TG executes series of SQL statements which are registered by users arbitrarily.
Therefore, TG can access any user tables and data dictionaries. |
|
Q2 |
Can TG simulate multiple users accessing at the same time? |
|
A2 |
Yes.
TG generates multiple virtual clients and this virtual clients send queries on the target database server.
Incidentally, at TG we call THREAD "Agent". The number of agents TG can generate is between 1 and 2000.
Each agent connects to the database and execute transactions separately. |
|
Q3 |
Can TG generate keys follow definite laws and access different data according to these keys? |
|
A3 |
Yes.
TG supports 5 type of random variables. They are : NUMBER, CHARACTER, DATE, LIST, AGENT-ID.
With these variables in the WHERE statemet, TG can access various data every time it execute transactions. |
|
Q4 |
Can TG simulate a repetition of CONNECT TO and DISCONNECT FROM a database server? |
|
A4 |
Yes.
Use the parameter "EXECUTION_COUNT" and "RECONNECT_WAIT". With these parameters, Agents(Virtual client) execute transactions specified times and disconnect from the target database server.
Next, wait for a specified period and re-connect to it. |
|
Q5 |
Does TG support databases except ORACLE? |
|
A5 |
YES.
Until TG version 0.72, TG was supporting ORACLE database only. But, TG version 0.80 has begun supporting
various databases on a trial basis. Now "MySQL" and "PostgreSQL", "SQL Server" were confirmed to work successfully with TG.
About another databases with JDBC driver provided, TG would be able to connect to them. |
|
Q6 |
Can TG execute PL/SQL as a transaction? |
|
A6 |
YES.
You can execute stored procedures as a transaction using "call <procedure name>" in the configueation file(tg.conf).
At the moment, TG can support following SQL statements:
- INSERT, DELETE, UPDATE
- SELECT
- COMMIT,ROLLBACK
- CREATE, DROP, ALTER
- GRANT, REVOKE
- TRUNCATE
- Stored procedure |
|
