I found the easiest way to do this was with a little Visual Basic App
using the ODBC driver. This gives you a lot more control over what
happens.
My App for example inserts a number of records in different tables
and then runs some select statements to check performance, I can set it
to run this sequence a number of times, and therefore check the performance
as the number of records in the DB rises.
for i = 1 to 1000
insert 1000 records into table a log time taken
insert 100 records into table b log time taken
select from a,b log time taken
next i
The number of records entered and the number of loops can be taken from user
input.
This then shows any degredation in performance as the total number of
records rises.
If you want more information on how to do this let me know.
Oliver.
"Mike" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> I'm a beginner in Cach�.
> For a simple performance-test I just want to exexute some SQL-Statements
successive
> without user-interaction.
>
> What is the best tool for this ?
> SQL-Manager ? Is there a special speparator to put between sql-statements
> Or is it cterm ? How to connect ?
> Or is it an other tool ?
> I can't find an answer in the documentation
>
>
